You will not be able to do it during the mail merge operation. The the
article "Finding and replacing characters using wildcards" at:
http://www.word.mvps.org/FAQs/Genera...gWildcards.htm
does however contain a section on how to reverse such information.
You may need to use a catalog (or in Word XP and later it is called
"directory") type mail merge to bring the information into Word so that you
can change the order and then use that file as the data source. In the
catalog or directory type mailmerge main document, insert the merge fields
into the cells of a one row table, execute the merge to a new document,
execute the Wildcard Replace, then insert a row at the top of the table into
which you insert names to be used as field names in your mailmerge and then
save that file and use it as the 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
"Plum3pc" wrote in message
...
my data source is has last name, first name both listed in field F1. How
can
I mail merge it in reverse to read in my letter
To the Parents of F1 and have it come out
To the Parents of John Jones instead of Jones, John.
Do I have to redo my data source and divide my names into two seperate
fields?