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 / November 2007

Tip: Looking for answers? Try searching our database.

Multiple Names in merge field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CindyC - 09 Nov 2007 20:22 GMT
How do I format a merged field to display multiple addressees correctly?
ex. Dear John Smith and Robin Reed

I put both first names into one field and both last names into another, but
I don't know how to get them to match properly.

Thanks
Doug Robbins - Word MVP - 09 Nov 2007 20:54 GMT
Mail merge does not have the ability to manipulate merge fields in that way.

It would be possible to write a macro that modifies the data source to split
each of the merge fields containing the names on the space between the first
name and the last name so that you would have separate first name fields and
separate last name fields for each individual.

With a little bit of fiddling, that could also be done using the Convert
Table to Text and vice versa that is available in Word.

To do that, you would copy the column of names to a new document, Convert it
to Text, then use Convert it to Table to convert it back to a table,
selecting a space as a separator so that you then got a two column table,
then insert the necessary field names in the first row and then copy and
paste the two columns back into the original data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> How do I format a merged field to display multiple addressees correctly?
> ex. Dear John Smith and Robin Reed
[quoted text clipped - 4 lines]
>
> Thanks
 
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.