 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2004contacts
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 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.  SignaturePlease 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 > have a question. Can you > use contacts that are in an Excel spreadsheet in a Word document for a [quoted text clipped - 8 lines] > Thanks, > Mindy It shouldn't matter what format the data file is in, provided the e-mail addresses it contains are in the correct format. eg name@isp.com 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. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > have a question. Can you > use contacts that are in an Excel spreadsheet in a Word document for [quoted text clipped - 6 lines] > Thanks, > Mindy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.