Emailing from lists in Access

[Guest]

I currently have a form which lists all Candidates on the system that I have
selected with their email address. What I need to do is email Everybody on
the list about jobs that they have applied for. Would anybody know what the
code would be to add to an 'onclick' button whereby it would email everybody
on the list, but all names would be in the BCC box so that no either
candidate would see anyone elses email address (confidentiality).

Many thanks.

 

[Sandra Daigle]

Hi Kerry,

Here are some links to articles that describe exactly how to do this:

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Outlook for the Summer (Programming Microsoft Outlook Objects)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office071299.asp

For more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm