Export to a list in Word...

[Guest]

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!

 

[Guest]

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.

 

[Guest]

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....

 

[Joseph Meehan]

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....

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

 

[Guest]

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.

 

[Guest]

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

 

[Joseph Meehan]

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...

You can import all of them into Outlook and then make groups in Outlook
to bring the number down to manageable sizes. I find that some SPAM filters
kick in at about 15 names.

 

[Guest]

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?

 

[Joseph Meehan]

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?

From the Access F1 help file:


Export a datasheet to a delimited or fixed-width text file:

In the Database window, click the name of the table, query, view, or stored
procedure you want to export, and then on the File menu, click Export.
In the Save as type box, click Text Files (*.txt; *.csv; *.tab; *asc).
Click the arrow to the right of the Save in box, and select the drive or
folder to export to.
In the File Name box, enter a name for the file (or use the suggested name),
and then click Export.
Microsoft Access starts the Export Text Wizard.
Follow the directions in the dialog boxes. Click Advanced to create or use
an import/export specification.



Load the output of a table, query, form, or report into Microsoft Word:

In the Database window, click the name of the datasheet, form, or report you
want to save and load into Microsoft Word. To save a selection of a
datasheet, open the datasheet and select the portion of the datasheet before
continuing.
On the Tools menu, point to Office Links, and click Publish It with
Microsoft Word.

 

[Guest]

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!

 

[Joseph Meehan]

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!

You might be able to create-record a macro and run that with a button
click. Kind of a messy way of doing it by it should work.