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 / September 2004

Tip: Looking for answers? Try searching our database.

Merge w/varying amount of rows to repeat for each company

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cerri starr - 02 Sep 2004 01:39 GMT
I am trying to make a mail merge document that will list multiple items for
one company in the letter.  For example:

Company A        Product 1
Company A        Product 2
Company B        Product 3
Company B        Product 4
Company B        Product 5

So, I want to send company A one letter with products 1 & 2 listed and I
want to send Company B one letter with products 3, 4 & 5 listed.  

All I can figure out is how to repeat a set number of rows, which doesn't
work because the number of products varies for each company.  Or how to make
a separate letter for each product, which I don't want to do, because I don't
want to send multiple letters to one company.

If anyone can please tell me how to accomplish this, I would be very grateful.

Thank you!
Doug Robbins - 02 Sep 2004 03:08 GMT
See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's
website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am trying to make a mail merge document that will list multiple items for
> one company in the letter.  For example:
[quoted text clipped - 19 lines]
>
> Thank you!

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.