Mailmerge records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo Davis - 23 Nov 2006 14:28 GMT

I have a mail merge set up which links to a spreadsheet. The data from the
spreadsheet is from our HR database and lists all the qualifications that
employees have. However, in excel it will list the same person several times
and treat it as a new record. therefore each employee gets as many letters as
qualification. Is there anyway i can get the mail merge to recognise a unique
reference and group them together.

Reply to this Message

Graham Mayor - 23 Nov 2006 14:59 GMT

See How to use mail merge to create a list sorted by category in Word 2002 -
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 have a mail merge set up which links to a spreadsheet. The data
> from the spreadsheet is from our HR database and lists all the
[quoted text clipped - 3 lines]
> i can get the mail merge to recognise a unique reference and group
> them together.

Reply to this Message