contacts

[Mindy]

have a question. Can yo
use contacts that are in an Excel spreadsheet in a Word document for a mai
merge? I tried it once and when I clicked "electronic mail" in the mai
merge wizard, it didn't recognize any of the email addresses. When you do
mass email do the contact information have to come from Microsoft Outlook
If you know the answer and wouldn't mind helping me, I would reall
appreciate it

Thanks
Mindy

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

No, it should not be necessary for the data to have to come from Outlook.
If the Excel data source contains valid email addresses in one of the fields
and you select that field as the source of the email addresses, it should
work.

Under Tools>Options>General, check the "Confirm conversion at Open" box and
then try any different connection methods that offer themselves when you
select the datasource.
--
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

 

[Graham Mayor]

It shouldn't matter what format the data file is in, provided the e-mail
addresses it contains are in the correct format. eg (e-mail address removed)
If the field is called email I believe that field will automatically be
inserted. If not you can pick which field contains the email address.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>