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 / February 2004

Tip: Looking for answers? Try searching our database.

problems merging names

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mindy - 02 Feb 2004 18:36 GMT
Hi.  I'm doing a mail merge for the first time and I cannot get it to put "dear" then the correct solutation, it just puts To whom it may concern.  The .csv file I'm using had the first and last name in the same cell.  I did a sample sample and I split the names up into two columns, first and last names .  When I tried to do a mail merge in Word it still doesn't recognize the name and just put To whom it may concern.  If someone could help me figure this out,  I would really appreciate it.  Thanks, Mindy
Peter Jamieson - 03 Feb 2004 08:40 GMT
What are your name fields called? Word has to guess which fields contain the
names you want to use, and recognises certain field names but not others. SO
if you use the field name "Name", Word may not know where to get the data to
put in the Greeting line. So when you insert your greeting line, use the
Match fields button to tell Word what the appropriate field names in your
document are.

Another way to do this is to use individual nested fields - you can create
these using ctrl-F9 to insert each pair of {} and alt-f9 to toggle between
"codes" and "results" view. If you just have one field called "mynamefield"
with the name you want to use, you would probably need something like

{ IF "{ MERGEFIELD mynamefield }" = ""
"To whom it may concern"
"Dear { MERGEFIELD mynamefield }," }

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Hi.  I'm doing a mail merge for the first time and I cannot get it to put "dear" then the correct solutation, it just puts To whom it may concern.
The .csv file I'm using had the first and last name in the same cell.  I did
a sample sample and I split the names up into two columns, first and last
names .  When I tried to do a mail merge in Word it still doesn't recognize
the name and just put To whom it may concern.  If someone could help me
figure this out,  I would really appreciate it.  Thanks, Mindy
Cindy M  -WordMVP- - 03 Feb 2004 23:23 GMT
Hi =?Utf-8?B?TWluZHk=?=,

It always helps to mention the version of Word involved so that we can
better picture what the problem might be.

> I'm doing a mail merge for the first time and I cannot get it to put "dear" then the correct solutation, it just puts To whom it may concern.
The .csv file I'm using had the first and last name in the same cell.  
I did a sample sample and I split the names up into two columns, first
and last names .  When I tried to do a mail merge in Word it still
doesn't recognize the name and just put To whom it may concern.

I get the impression you're trying to use the "Greeting line" field in
word 2002 or 2003?

The problem is that your field names have to match what Word expects
them to be. In the "Greeting line" dialog box click the "Match fields"
button. Now you can tell Word which fields in your csv file match what.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
 
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.