Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Names in merge field
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Names in merge field
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. -- 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 "CindyC" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple line field names in Excel 2002 | Mailmerge | |||
Changing Merge Field Names | Mailmerge | |||
retrieving merge field names | Mailmerge | |||
Word merge field names vs. Excel merge field names | Mailmerge | |||
mail merge field names | Mailmerge |