Reply
 
Thread Tools Display Modes
  #1   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

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge to Email not using email address in data file

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.


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



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge to Email not using email address in data file

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

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

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




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge excel data incuding email address Bolzey Mailmerge 2 October 25th 07 04:03 AM
How to save email address and subject line in Word's email functio Chittapoo Microsoft Word Help 0 February 2nd 07 08:46 PM
merge a single email to all the email address for a contact Tony Mailmerge 1 July 25th 06 04:56 AM
Remove an email address from suggested email recipients in Outlook d Microsoft Word Help 1 April 2nd 06 08:30 PM
Create macro to write email address in email window albycindy Microsoft Word Help 3 August 22nd 05 07:57 PM


All times are GMT +1. The time now is 06:13 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"