Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jeans
 
Posts: n/a
Default Mail Merge with duplicate rows of data

Using Word 97 (sorry!)

My data source includes several rows per one record (ie like an invoice
which would contain several items per one customer).

I am trying to create a document that puts all the rows for one customer on
each page (ie starts a new page for each customer). However the document
doesn't know when to "end" the rows for that customer so the rows for the
next customer are included on the page with the previous customer.

I am trying a "NEXT Record if" statement along the lines of:

{NExtIF {Mergefield Customer_nr} = {mergefield Box_no} {Mergefield Pub_name}
?????
I am thinking that I either need to enter an instruction to start a new page
^m (?) or is there a "distinct" instruction that I could use?




 
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
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Mail merge data source problem campwes Mailmerge 1 January 25th 05 07:16 PM
can I merge two sets of address data in Word Mail merge kenben Mailmerge 1 December 4th 04 04:01 PM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 01:50 AM.

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"