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?
Graham Mayor - 27 Aug 2006 06:42 GMT
Fixing your data source is the only solution. You have not mentioned what
your data source is so it is difficult to advise the best next step, but it
would be simple to do in Excel, and relatively simple to do in Word using a
wildcard replace - see http://www.gmayor.com/replace_using_wildcards.htm
where you will find an example.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> 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
[quoted text clipped - 4 lines]
> Do I have to redo my data source and divide my names into two
> seperate fields?
Doug Robbins - Word MVP - 27 Aug 2006 06:51 GMT
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/General/UsingWildcards.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.

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
> my data source is has last name, first name both listed in field F1. How
> can
[quoted text clipped - 5 lines]
> Do I have to redo my data source and divide my names into two seperate
> fields?