Results 1 to 3 of 3

Email database object & email field

  1. #1
    rwright46 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    1

    Email database object & email field


    I have a table that has my email addresses, and I want to send individual reports to each email address. How do i have the "TO" field populate my email address and seperate each report?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    6,948
    a form has a list of persons ID and emails.
    a combo box with a report to send.
    the query of the report looks at the listbox of IDs to pull only that persons data.
    ...select * from table where [id] = forms!myForm!lstEmails

    a button to scan the listbox, select 1 at a time, email the report.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,289
    Yes, can use a listbox to select particular addresses. Or open a recordset in VBA and loop through records. Open report filtered to ID in record, send email with report pdf attachment via SendObject to the email address in record, close report, move to next record, repeat.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-27-2017, 11:31 AM
  2. Replies: 3
    Last Post: 12-28-2015, 03:11 PM
  3. Replies: 5
    Last Post: 05-07-2014, 08:25 AM
  4. Email Database Object
    By Meep in forum Access
    Replies: 3
    Last Post: 11-24-2012, 04:24 PM
  5. send email to email addresses in database?
    By cnstarz in forum Access
    Replies: 5
    Last Post: 03-02-2011, 08:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums