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 / March 2006

Tip: Looking for answers? Try searching our database.

next record if id is the same as the last value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
a - 31 Mar 2006 12:26 GMT
Hello,
i've tried searching previous threads but havn't found the answer yet.
we are mail merging a document in word 2003, at the top of the document we
have the address details (invoice header).
Then we have a table where we wish to show the invoice lines relating to
this particular invoice.
how can we do a "next record if "where it looks at the current ID value in
the mail merge( we are merging from an excel doc) to see if it is the same
as the preview ID value.

At present if an invoice has 5 lines then 5 seperate pages are being printed
out.

Please help!!!!

Thanks
Doug Robbins - Word MVP - 31 Mar 2006 15:21 GMT
You are trying to perform a "multiple items per condition (=key field)"
mailmerge, which requires a bit more than a straightfoward Word Mailmerge.

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello,
> i've tried searching previous threads but havn't found the answer yet.
[quoted text clipped - 12 lines]
>
> Thanks

Rate this thread:






 
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.