Merge to Email not using email address in data file

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

 

[Peter Jamieson]

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

 

[Foose]

There are 5 columns in the spreadsheet. Fname, Lname, EMail, Date and
Dollar. Of which I have Tim under fname, Smith under lname, (e-mail address removed)
under email, 1/09/08 under date and 50 under dollar. I'm also running
Outlook, Word and Excel 2003 SP2.

 

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