Reply
 
Thread Tools Display Modes
  #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?




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

Word doesn't really do this, but various approaches are outlined on Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/

Look for Mail Merge FAQ, Special Merges, Multiple Items per Condition

Peter Jamieson

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






  #3   Report Post  
 
Posts: n/a
Default

HI,

I understand what you are trying to do. I have a number of clients doing
this with my 3rd party commercial software package, OctoTools. OctoTools
however is aimed at an automated solution for medium to high volume
througputs and will output both PDF (for automatic emailing and web posting)
and print output, enhanced as you specify with its front end forms
designer/template from your application text or access/mySQL database. If
you are looking for a commercial solultion feel free to visit
www.octotools.com and give me a call at 978 535-7676. Thank you for your
time.

Larry T
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
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 09:34 PM.

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

About Us

"It's about Microsoft Word"