[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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



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

[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?


"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

[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

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