Mail merge email to email addresses in DB

[Mike Calder]

--
G'day ,

I am trying to do a mail merge email to members from an Excel membership
database that includes their email addresses as one column/field. The
column heading is just "Email" (no quotes).

I see this in the Word 2002 Help file:-
1.. Click Electronic Mail.
2.. In the Merge to E-mail dialog box, finalize the distribution
settings.
How?

1.. In the To box, verify that Email_Address or the equivalent is
displayed. This ensures that Microsoft Word merges e-mail addresses into
the To line of your messages, not some other merge field information.

Does this mean that the email address column heading must be in the form
"Email_address"?.

Does this field also have to be in the body of the message like an
address?

To: <<Email_address>>

Blah blah.....

Thanks for any enlightenment.

Win XP - Word 2002

Mike CALDER
EMAIL: (e-mail address removed)
WEB: http://members.optusnet.com.au/mikecalder/

 

[Peter Jamieson]

I see this in the Word 2002 Help file:-

1.. Click Electronic Mail.

Can we assume you saw this link and clicked it...

2.. In the Merge to E-mail dialog box, finalize the distribution
settings.

....and got this?

How?

If so, complete the fields in the dialog box (select a "To" field, type a
subject, select a Mail format, change th record selection as required, and
click OK). Which is obvious, so not sure what problem is making you ask
"How", other than the ones later in your message.

Does this mean that the email address column heading must be in the form
"Email_address"?.

No. In your case, it should be "Email".

Does this field also have to be in the body of the message like an
address?

To: <<Email_address>>

No. Word merges your document into either a plain text message body, an HTML
mail format body, or an attachment depending on your previous selections,
then (in effect) inserts the other info. into a mail "envelope". WOrd
doesn't pick up any of the envelpoe information from the body of your mail
merge main document.