 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / March 2008Skip if duplicate
I'm trying to merge a list of names by category. Is there a way to do this directly into a one column list? If not, can I merge them into two columns and avoid repeating the multiple categories? i.e. Instead of: Red Chris Red Tom Should be: Red Chris Tom Or better still: Red Chris Tom Thanks See 'How to use mail merge to create a list sorted by category - http://support.microsoft.com/?kbid=294686 '  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I'm trying to merge a list of names by category. Is there a way to > do this directly into a one column list? If not, can I merge them [quoted text clipped - 11 lines] > Tom > Thanks Thank you! I printed it out and have tried it once - it did not work - will try again. However, in the meantime, if I am extracting the data from CRM via a mail merge add-on, will this formula still work? > I'm trying to merge a list of names by category. Is there a way to do this > directly into a one column list? If not, can I merge them into two columns [quoted text clipped - 11 lines] > Tom > Thanks If you have a data file that has the two fields; you substitute the field names in the example; the data is sorted on the 'colour' field; you set the merge type to directory/catalog and merge to a new document then it should work. { IF{ MergeSeq } = 1 "{ Mergefield Colour } " }{ SET Place1{ Mergefield Colour } } { IF{ Place2 } <> { Place 1 } " { Mergefield Name }" }{ SET Place2 { Mergefield Colour } } Note the quotes and the line breaks. Colour is the field containing RED. Name is the field containing NAME Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you! I printed it out and have tried it once - it did not work > - will try again. However, in the meantime, if I am extracting the [quoted text clipped - 15 lines] >> Tom >> Thanks |
Reply to this Message |
 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.