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 / August 2006

Tip: Looking for answers? Try searching our database.

reversing "Last, first" in mail merge from one data source field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Plum3pc - 27 Aug 2006 05:23 GMT
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?
 
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.