Email list from Access to Outlook: How?

[Paul Brady]

This must be a common operation, but I have searched this newsgroup
and have wrestled with the help messages, and I seem to need help with
this simple task.
I have an Access 2000 database which, via a query, can
generate a list of e-mail addresses. I can export this list, if
necessary. There may be hundreds of names in this list.
Now, I want to send e-mail to everyone on this list. I can
copy the list onto the clipboard (all 300 names!) and jam it into the
Outlook address field (Ugh!), but what I really want is for Outlook to
simply send the email to everyone on the list.
Can someone point me to a FAQ or tutorial on how to get
Outlook to send the email to everyone on the Access-generated list? I
have figured out how to populate an Outlook address book with this
list, but once again, I don't want to put all 300 names from the
address book into the email address.
Thanks very much. Pete Brady

[Tony Toews [MVP]]

Re: Email list from Access to Outlook: How?

Paul Brady <ptbrady@aol.co mwrote:

> Can someone point me to a FAQ or tutorial on how to get
>Outlook to send the email to everyone on the Access-generated list? I
>have figured out how to populate an Outlook address book with this
>list, but once again, I don't want to put all 300 names from the
>address book into the email address.

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

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/