Results 1 to 3 of 3
  1. #1
    ljw121 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    2

    Sending email to multiple recipients returned from a report

    Hi,



    I'm trying to find a way to send an email to all the addresses returned from a report.

    This is the setup I currently have:

    I have a table called contacts and a table called searches.

    I have a form based upon the searches table which is used to input criteria to search against the contacts table.

    The user specifies a criteria using the form and clicks a button which loads a report (using a SQL Query) to show all the matches from the contacts table. I would then like a subsequent button to email all of the matches in that report. I'd like the option to enter the subject text in outlook prior to sending and all the email addresses should to be in the BCC field.

    I've been searching on forums but can't find the definitive answer.

    Can anybody help?

    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  3. #3
    ljw121 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    2
    Quote Originally Posted by RuralGuy View Post

    Thanks, unfortunately this page shows how to loop and send an email to every entry in the record set.

    What I am looking to do is loop through the record set and write every entry in the emailaddress column into the BCC field of the Outlook email (using SendObject??)

    Does that make sense? Do you need any more information?

    Thanks for your help.

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

Similar Threads

  1. sending gmail email through access
    By TheShabz in forum Programming
    Replies: 20
    Last Post: 02-19-2012, 12:24 PM
  2. Email sending
    By Steven.Allman in forum Access
    Replies: 25
    Last Post: 06-21-2010, 09:37 AM
  3. Sending email
    By nashr1928 in forum Reports
    Replies: 8
    Last Post: 04-27-2010, 11:14 PM
  4. Replies: 1
    Last Post: 03-09-2006, 01:50 PM
  5. Sending email via Outlook (and Exchange2003) from Access2003
    By Larry Elfenbein in forum Programming
    Replies: 0
    Last Post: 11-15-2005, 09:03 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
  •  
Other Forums: Microsoft Office Forums