Skip if duplicate

[Sparkie]

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

 

[Graham Mayor]

See 'How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686 '

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Sparkie]

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?

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>