Merge to Email not using email address in data file

F

Foose

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.
 
P

Peter Jamieson

Is the field in your Excel sheet the /name/ e.g. Tim Smith or an address
(e.g. [email protected]) ? If it is an address, does it contain anything
other than that address? (e.g. a display name in brackets) ?
 
F

Foose

There are 5 columns in the spreadsheet. Fname, Lname, EMail, Date and
Dollar. Of which I have Tim under fname, Smith under lname, [email protected]
under email, 1/09/08 under date and 50 under dollar. I'm also running
Outlook, Word and Excel 2003 SP2.
 
P

Peter Jamieson

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) ?
 
Top