View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Foose Foose is offline
external usenet poster
 
Posts: 2
Default Merge to Email not using email address in data file

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

"Peter Jamieson" wrote:

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

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

"Foose" wrote in message
...
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.