Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2004

Tip: Looking for answers? Try searching our database.

Mail Merge uses Outlook instead of Excel data source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karminak - 20 May 2004 22:36 GMT
I am unable to do mail merges for the last few weeks.  Since I've downloaded all the "Security" updates from
Microsoft.  I am using Office 2003 so Word, Excel and Outlook are 2003. I am trying to do a simple email merge with one merge field: <First Name>. The data source is an Excel spreadsheet with email address, first name, last name and company name

I open up the merge document and the data source and can preview the merged letters. I then merge to email and
change mail format to plain text and click OK. Then I get dialog boxes trying to match my email addresses with ones
in my Outlook address book. If the person in theExcel list is called Ann and I have an Ann in my address book,
it sends the email to the Ann in the address book not the Ann in the data source. These emails are sent only to
recipients whose first name  happens to reside in my address book and matches the first name in the Excel file. Emails are not sent to the email addresses in the data source file. Aside from the fact that the new security settings in Outlook
2003 now require that I click OK to approve each email (which I bypassed with a utility) now I have this problem
with the data source. Frankly, my IT guy does not know how to fix the problem other than to uninstall Office
2003 and install Office 2000

Any assistance would be appreciated to fix this problem

Thank you

Karminak
Peter Jamieson - 21 May 2004 10:20 GMT
It sounds as if you are specifying the first name in your dataq source as
the e-mail address for the merge. You have to specify the e-mail address
field in the data source as the e-mail address for the merge. Word cannot
guess that the e-mail address in your data source is the field that it needs
to use.

Signature

Peter Jamieson

> I am unable to do mail merges for the last few weeks.  Since I've downloaded all the "Security" updates from
> Microsoft.  I am using Office 2003 so Word, Excel and Outlook are 2003. I am trying to do a simple email merge with one merge field: <First Name>. The
data source is an Excel spreadsheet with email address, first name, last
name and company name.

> I open up the merge document and the data source and can preview the merged letters. I then merge to email and
> change mail format to plain text and click OK. Then I get dialog boxes trying to match my email addresses with ones
> in my Outlook address book. If the person in theExcel list is called Ann and I have an Ann in my address book,
> it sends the email to the Ann in the address book not the Ann in the data source. These emails are sent only to
> recipients whose first name  happens to reside in my address book and matches the first name in the Excel file. Emails are not sent to the email
addresses in the data source file. Aside from the fact that the new security
settings in Outlook
> 2003 now require that I click OK to approve each email (which I bypassed with a utility) now I have this problem
> with the data source. Frankly, my IT guy does not know how to fix the problem other than to uninstall Office
[quoted text clipped - 5 lines]
>
> Karminak
 
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.