FIRST RECORD

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen Long - 02 Dec 2005 15:22 GMT

I have a mailmerge document that is pulling data from a spreadsheet, with a
certain number of lines that have the same reference number - I am creating a
statement to send out to clients, so each client may have only one line in
the spreadsheet or multiple.

The top half of my document works well, pulls through into a table the
relevant lines from the spreadsheet.

The bottom half of my document is a repetition of the top, however, it only
pulls through the last line of the spreadsheet for each reference number
instead of all. I cannot get it to start at the top again and work it's way
down, is there a way to force it back to the first record?

Regards

Karen Long
IT Manager

Reply to this Message

Doug Robbins - Word MVP - 02 Dec 2005 17:40 GMT

Sorry, but no, there isn't.

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

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

Or take a look at the following Knowledge Base Articles

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665

http://support.microsoft.com/default.aspx?scid=kb;en-us;294686

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 a mailmerge document that is pulling data from a spreadsheet, with a
> certain number of lines that have the same reference number - I am
[quoted text clipped - 16 lines]
> Karen Long
> IT Manager

Reply to this Message