Mail Merge and Word Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amanda - 31 Aug 2007 13:36 GMT

I have set up a datasource and mail merge, however the datasource contains
several records for 1 person as they may have done several courses. When I
do my merge I want to insert the persons name (we have a unique field
username) and then in another area all of the courses they have been on. Can
anyone help me with how I use the "next record if" word field to do this.
How can I get it to search the list for where a persons username appears more
than once and then insert the course they attended.

Reply to this Message

Graham Mayor - 31 Aug 2007 14:02 GMT

This is not at all straightforward - 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 have set up a datasource and mail merge, however the datasource
> contains several records for 1 person as they may have done several
[quoted text clipped - 4 lines]
> the list for where a persons username appears more than once and then
> insert the course they attended.

Reply to this Message

Doug Robbins - Word MVP - 31 Aug 2007 21:20 GMT

Here some other sources of information on how to do it:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

http://cornell.veplan.net/article.aspx?&a=3815

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have set up a datasource and mail merge, however the datasource contains
> several records for 1 person as they may have done several courses. When
[quoted text clipped - 6 lines]
> more
> than once and then insert the course they attended.

Reply to this Message

Rate this thread: