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
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Sparkie wrote:
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?
"Sparkie" wrote:
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