Create Mass Mailing List for Outlook

[Vicki]

I want to take the email addresses stored in one table and
create a mass mailing to paste into Outlook. Any
suggestions, ideas, examples on doing this are greatly
appreciated. Thanks in advance.

 

[Leonard Selmani]

If you want to insert all the email addresses in Outlook,
then you'll have to work from access, using CODE. CODE is
what makes it all work. I'd say you create a module that
iterates through all the email addresses and adds them one
by one to the TO field. You can then either enter your
text, or pre write the text and insert it in the Body
field. I did this for about 5000 customers. It could be
slow, but it works. Outlook 2000 will warn you that a
process is trying to access it and if you want to allow
it, say yes..and voila...you should have your email ready
to be sent

 

[Kevin]

You would probably use the docmd.sendobject command. That
is assuming you want to create the text of your message in
a report of some type. Check help. In the command string
you will have one variable which is the recipient list.
Concatenate a string variable for this part of the command
string just like it will be in outlook (i.e.
(e-mail address removed), (e-mail address removed), etc., etc.)
After you build this string you will use it when you call
the docmd.sendobject command.
Read help for the docmd.sendobject command and it should
make sense.

This will be more efficient than sending each name one at
a time to outlook.

Hope this helps!