Export to a list in Word...

S

Suzy

Hi there!

I have a query which pulls out email addresses for clients who wish to
receive a newsletter via email. As there are 500+ addresses to email to I
plan to split these into smaller groups for sending. The easiest way I can
think of is to export the email addresses into a comma seperated 'list' in
Word (which I can then cut and paste sections at a time into an email
message).

How can I achieve this 'list'? Or can anyone suggest a better way to handle
this?

My query "EmailAddressesNewsletter" contains, amongst others, the field
"EmailAddress".

Thanks in advance!
 
E

Eric Blitzer

Have you tried using Distribution lists? You would mainain the list in
Outlook therefore making it easier to update and not having to change your
Access app.
 
S

Suzy

Ah... not as easy as all that! This is part of a client database which also
tracks client's other contact details, treatment history, product purchase
history, and produces various reports... would rather keep it all the info in
once place....
 
S

Suzy

I suspect not 500+ addresses at once... I'm sure if I sent a message with
500 email addresses in it the message would be caught up in spam filters...

:

I believe you can export address information directly from Access and put it
in Outlook. I don't know what versions may be required.
 
E

Eric Blitzer

Maybe one of these links will help you
Here are some links to articles that describe exactly how to do this:

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Outlook for the Summer (Programming Microsoft Outlook Objects
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office071299.asp

For more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm
 
S

Suzy

OK... let's forget for the moment that I am working with email addresses...
can I just focus on the fact that I want to export a list separated by commas
into a Word document... can it be done?
 
S

Suzy

Thanks Joseph! My F1 help just would not find that information.

I would like to create a button which does this job... are you able to help
me with that? Ideally the button will select the "EmailAddress" from the
"EmailAddressesNewsletter" query and load the output into Microsoft Word.

I have created this database for my sister who is severely technologically
challenged and I think a button which handles all of this would be the best
option for her.

Many thanks in advance!
 
Top