Access and emailing

[Guest]

Can a field in a Access database be used to create a mail merge in Outlook?
I have been given an existing Access database that I have to administer. It
contains a variety of fields containing different contact details. Is anyone
able to tell me how to export the email field directly to create a BCC group
email?

Cheers

 

[Arvin Meyer [MVP]]

Try this:

http://www.datastrat.com/Download/EmailSenate2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[UpRider]

KK, the short answer is YES. There are a couple of approaches. You can use
Office Automation to actually create an instance of Outlook with the New
Mail window open with the TO: and Body filled in, as well as a complete BCC
list, all ready to go, including an attachment if you wish.
Another approach is to create a contact folder in Outlook and have Access,
thru Automation, fill it with your address list. Then you go to Outlook and
run a mailmerge to email. This works great, but does NOT allow an
attachment. The upside is that it allows personalization of each recipient's
email, unlike the previous BCC method.
Another approach would be to have Access export a csv file. Then you would
go to Outlook and import it into a contacts folder. From there, you could do
a mailmerge, or mail directly via the BCC route. This last method requires
the least amount of code.
Give us a hint as to which method strikes your fancy, and the group will, I
hope, get you going.

UpRider