Reply
 
Thread Tools Display Modes
  #1   Report Post  
markmidwest
 
Posts: n/a
Default Duplicate Records Merging with Access

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
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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
"markmidwest" wrote in message
...
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



  #3   Report Post  
markmidwest
 
Posts: n/a
Default

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

Thank you for your response.

Mark

"Peter Jamieson" wrote:

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
"markmidwest" wrote in message
...
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




  #4   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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

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

Thank you for your response.

Mark

"Peter Jamieson" wrote:

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
"markmidwest" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access records pasted by default as Word table? elessem Microsoft Word Help 1 May 27th 05 10:50 AM
Word 2003 receives no records from Access 2003 query Tor Michal Kinn Mailmerge 1 April 7th 05 11:26 AM
Word Document: merging a lot of info from Access pepenacho Mailmerge 1 March 22nd 05 10:01 PM
How do I get UK date format merging into word from Access? Gavvers Mailmerge 3 March 18th 05 01:24 PM
Merging data from two consecutive access records in Word 2002 Frank Spade Mailmerge 3 December 17th 04 10:51 AM


All times are GMT +1. The time now is 11:23 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"