send email to all email address in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 10 Jun 2004 21:04 GMT

I have a word document and I want to be able to send it
to all the email address that are stored in access (XP).
How would I do this?

Reply to this Message

Doug Robbins - Word MVP - 11 Jun 2004 10:04 GMT

Use mailmerge with the access table containing the email addresses as the
datasource and execute the merge to email. You will then be asked to
nominate the field that contains the email addresses.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have a word document and I want to be able to send it
> to all the email address that are stored in access (XP).
> How would I do this?

Reply to this Message

Dan - 11 Jun 2004 15:28 GMT

That worked excellent now how would I set it up so that I
can just click a button and it will automaticallly select
my database and all the options that I want and send it.

Reply to this Message

Doug Robbins - Word MVP - 12 Jun 2004 01:21 GMT

From the Visual Basic Help file

This example merges the document named "FormLetter.doc" with its attached
data document and sends the results to the e-mail addresses stored in the
Email merge field.

With Documents("FormLetter.doc").MailMerge
.MailAddressFieldName = "Email"
.MailSubject = "Amazing offer"
.Destination = wdSendToEmail
.Execute
End With

Signature

> That worked excellent now how would I set it up so that I
> can just click a button and it will automaticallly select
> my database and all the options that I want and send it.

Reply to this Message