Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Fort Worth, TX

    Unanswered: SendObject with email list

    I have a report that I send to various clients that I send as a spreadsheet. The query that it is based on filters the results by a combo box called CompanyName. I would like to have send object funtion send to the emails that are linked to the company that has been selected.
    Is it possible to do.
    I would also like the subject line to include todays date and the company name that was selected

  2. #2
    Join Date
    May 2010
    It should be possible to do.

    To be able to give you any guidance we will need more details about the table(s) where the email addresses are stored.
    Boyd Trimmell aka HiTechCoach (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Jun 2010

    Try Total Access Emailer

    I use Total Access Emailer from FMS to do this. It's a Microsoft Access add-in that lets you take a table with a list of email addresses (and other fields) and use those fields in your message.

    You can also attach files (such as as a spreadsheet from a table/query or PDF for a report). The best part is you can filter the table, query, or report by a field (or fields) in the table with the list of emails. For instance, I have a Customer ID that I can use to filter the report to just that customer's pages.

    Once you set up your email, you can run it over and over again using your current data, and it can update a field when the email is sent. You can also run it from VBA.

    More info and a demo here: Microsoft Access Email sent from your Access Databases with Merged Data and Reports in PDF and HTML

    Hope this helps.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts