Automating emails in Access 2003

[Guest]

I would like to send out a batch of form email based on the results of a
query in Access 2003. How do I do it using Outlook 2003?

 

[Brian]

I would like to send out a batch of form email based on the results of a
query in Access 2003. How do I do it using Outlook 2003?

I send email using a super little dll that I found here:

http://www.freevbcode.com/ShowCode.Asp?ID=109

It's really easy to use (much easier than automating Outlook) and works
really well. Don't worry if you haven't got Visual Basic, the download
includes the actual dll.

If you attempt to automate Outlook, be aware that you will be inundated with
infuriating security messages, each of which insists on a response. This
can't be turned off, but it can easily be circumvented using Redemption:

http://www.dimastr.com/redemption/

but, it costs money.

 

[Tony Toews]

I would like to send out a batch of form email based on the results of a
query in Access 2003. How do I do it using Outlook 2003?

You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separator character, such as comma or
semi-colon, and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

For Outlook see the Outlook specific links at the Access Email FAQ at
my website.
http://www.granite.ab.ca/access/email/outlook.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm