Duplicate data reappears in Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KristiK - 06 Nov 2007 21:06 GMT

Trying to do a simple mail merge from an excel spreadsheet. The first page
looks great, but then the second page is the same data, less the first entry.
The third page is the same data, less the first and second entry. Probably
a simple fix...I would welcome your suggestions.

Signature

KristiK

Reply to this Message

Doug Robbins - Word MVP - 07 Nov 2007 01:15 GMT

Execute the merge to a new document if you want to see the labels as they
will appear when printed.

What you are doing at the moment is just stepping through the data source,
one record at a time and as there are multiple labels on the mail merge main
document, you are seeing each one (except for the first) multiple times.

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

> Trying to do a simple mail merge from an excel spreadsheet. The first
> page
[quoted text clipped - 3 lines]
> Probably
> a simple fix...I would welcome your suggestions.

Reply to this Message