duplication of records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Capn - 27 Aug 2005 16:57 GMT

Ok, I created a custom label of 4x6 which I need for my data, which the
directions I received from someone here, thank you by the way. I've done all
the merge fields and everything, their are two 4x6 areas on the sheet, but
when I go to the next page with the next 2 records, the last record on the
previous page, repeats again at the top of the next page, basically
duplicating every record, understand any of that? Any help?

Capt.

Reply to this Message

Doug Robbins - 27 Aug 2005 18:27 GMT

Does that happen when you actually execute the merge to a new document, or
are you just previewing the results? Your mailmerge main document should
consist of just one page. Do you have two pages in it?

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

> Ok, I created a custom label of 4x6 which I need for my data, which the
> directions I received from someone here, thank you by the way. I've done
[quoted text clipped - 4 lines]
>
> Capt.

Reply to this Message

Capn - 27 Aug 2005 18:56 GMT

There are going to be multiple pages, but it is in the preview part when you
go through and set up the merge fields and then preview it. I only have 40
records it is using in this database, many more in others, I just want to
make sure it won't duplicate everyone when I go to a larger database.
Thought maybe I missed something. Thanks.

> Does that happen when you actually execute the merge to a new document, or
> are you just previewing the results? Your mailmerge main document should
[quoted text clipped - 8 lines]
>>
>> Capt.

Reply to this Message

Doug Robbins - 27 Aug 2005 19:58 GMT

Try executing the merge to a new document. It should contain what you need
without any duplicates.

It sounds like you are using the Wizard (which does not really make it any
easier). I would suggest that the turn on the Mailmerge toolbar by
selecting Toolbars from the View menu and then select that item. It has
buttons on it that allow you to do all that you need to with mailmerge.

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

> There are going to be multiple pages, but it is in the preview part when
> you go through and set up the merge fields and then preview it. I only
[quoted text clipped - 14 lines]
>>>
>>> Capt.

Reply to this Message

Capn - 27 Aug 2005 22:58 GMT

Nope, didn't work, still duplicates all the records now it's in different
places instead of right afterwards. I did the propagate lables thing, does
that mess it up at all. Any help would be great, starting to get really
annoyed, my only other option is to do it one on a page.

Capt.

> Try executing the merge to a new document. It should contain what you
> need without any duplicates.
[quoted text clipped - 23 lines]
>>>>
>>>> Capt.

Reply to this Message

Doug Robbins - 28 Aug 2005 07:07 GMT

On the mailmerge main document there should be a <<Next Record>> field
before the first mergefield on the second label on the page.

As I understand it, you have two labels on the page, so each label in the
main,document should be the same except for the above <<Next Record>> field
in the second label

Mailmerge merges the records in the order that they appear in the
datasource, so if you are getting duplicates in different places then you
should check the data source for duplicates.

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

> Nope, didn't work, still duplicates all the records now it's in different
> places instead of right afterwards. I did the propagate lables thing, does
[quoted text clipped - 29 lines]
>>>>>
>>>>> Capt.

Reply to this Message

Rate this thread: