Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2005

Tip: Looking for answers? Try searching our database.

Mail Merge with duplicate rows of data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeans - 02 Jun 2005 16:17 GMT
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?
Peter Jamieson - 02 Jun 2005 16:54 GMT
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

> Using Word 97 (sorry!)
>
[quoted text clipped - 15 lines]
> page
> ^m (?) or is there a "distinct" instruction that I could use?
larrynospam@nospamjbmsystems.com - 02 Jun 2005 17:32 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.