View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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