Duplicate Records Merging with Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

markmidwest - 03 Jun 2005 18:41 GMT

I am creating a mail merge document using data from an Access database as the
source. The merge works fine but some records print twice on every letter
that they are merged into. I viewed the code & can't find any reason for it.

Any help would be greatly appreciated.

Thanks,
Mark

Reply to this Message

Peter Jamieson - 04 Jun 2005 07:20 GMT

Are you processingmultiple records per letter? Can you post the relevant
code (whether it is VBA, a sequence of field codes, or both) here please?

Peter Jamieson

>I am creating a mail merge document using data from an Access database as
>the
[quoted text clipped - 6 lines]
> Thanks,
> Mark

Reply to this Message

markmidwest - 13 Jun 2005 15:10 GMT

Yes, there are multiple records being merged into each letter. How can I
post the relevant code?

Thank you for your response.

Mark

> Are you processingmultiple records per letter? Can you post the relevant
> code (whether it is VBA, a sequence of field codes, or both) here please?
[quoted text clipped - 10 lines]
> > Thanks,
> > Mark

Reply to this Message

Peter Jamieson - 13 Jun 2005 19:10 GMT

Is it "field code" code, or VBA? If VBA, open the VBE editor and copy/paste
the relevant text into a message in this newsgroup/community. If it is merge
field code, at this point it would probably be easier to despam my e-mail
address and send me an e-mail with your Word document as an attachment.

Peter Jamieson

> Yes, there are multiple records being merged into each letter. How can I
> post the relevant code?
[quoted text clipped - 20 lines]
>> > Thanks,
>> > Mark

Reply to this Message