can I send a bulk email mailing from an access database?

[Guest]

can I send a bulk email mailing from an access database if one of the field
is "email" and contains my customers email address. I want to do this from
Access instead of creating a separate email list in Outlook

 

[Dave]

Sure can: use SendObject, like this:

DoCmd.SendObject acSendReport, strDocName, acFormatRTF,
strEmail, , , Nz(Me![txtSubject], ""), Nz(Me![txtMessage], ""), True

Check the help files on syntax, but the thing from the bulk mail point of
view is that you can loop through a list of recipients and either:

1. Build a list of e-mail addresses as strEmail

or

2. Send individual reports (or whatever) to each one as you repeat
the loop

In the example above, each recipient receives his/her own report, but the
subject line and message body are entered by the user on the form from which
the code is executed.

 

[Tony Toews]

can I send a bulk email mailing from an access database if one of the field
is "email" and contains my customers email address. I want to do this from
Access instead of creating a separate email list in Outlook

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.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