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 / January 2008

Tip: Looking for answers? Try searching our database.

Merge to Email not using email address in data file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Foose - 10 Jan 2008 23:39 GMT
I have records in my excel spreadsheet that have email addresses.  When I use
Words, merge to "email messages" it doesn't pick up the email address
assigned to that record in my spreadsheet.  I seems to pick up the email
address that are in my Outlook contacts.  Example I have a record in my excel
sheet that goes to Tim Smith, but when I merge it want's me to pick a Tim
from my contacts, and Tim Smith is not in my contacts.
Peter Jamieson - 11 Jan 2008 08:57 GMT
Is the field in your Excel sheet the /name/ e.g. Tim Smith or an address
(e.g. timsmith@myorg.org) ? If it is an address, does it contain anything
other than that address? (e.g. a display name in brackets) ?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I have records in my excel spreadsheet that have email addresses.  When I
>use
[quoted text clipped - 4 lines]
> sheet that goes to Tim Smith, but when I merge it want's me to pick a Tim
> from my contacts, and Tim Smith is not in my contacts.
Foose - 11 Jan 2008 16:39 GMT
There are 5 columns in the spreadsheet.  Fname, Lname, EMail, Date and
Dollar.  Of which I have Tim under fname, Smith under lname, TSmith@myorg.com
under email, 1/09/08 under date and 50 under dollar.  I'm also running
Outlook, Word and Excel 2003 SP2.

> Is the field in your Excel sheet the /name/ e.g. Tim Smith or an address
> (e.g. timsmith@myorg.org) ? If it is an address, does it contain anything
[quoted text clipped - 8 lines]
> > sheet that goes to Tim Smith, but when I merge it want's me to pick a Tim
> > from my contacts, and Tim Smith is not in my contacts.
Peter Jamieson - 11 Jan 2008 19:27 GMT
At the moment I can't replicate this. But at what point are you seeing the
messages/prompts? Also, which e-mail format are you using (HTML, plain text,
attachment) ?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> There are 5 columns in the spreadsheet.  Fname, Lname, EMail, Date and
> Dollar.  Of which I have Tim under fname, Smith under lname,
[quoted text clipped - 17 lines]
>> > Tim
>> > from my contacts, and Tim Smith is not in my contacts.
 
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.