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 / April 2007

Tip: Looking for answers? Try searching our database.

Mail Merge with multiple rows for each customer?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mary Beth McNabb - 24 Apr 2007 14:28 GMT
I have been trying to figure this one out for a few weeks now!  

I am trying to create a word doc that has credit info for each customer.  My
data source is an excel file.

I have figured out how to break pages for each new customer, but can't
figure out how to list each of their accounts on one page.  I have the pages
breaking when an account number changes.  

I want it to look something like:

Don Smith  account 123  
10.50
12.37
15.50
----------page break-----------
Fred Yoder account 124
12.00
10.00
15.00

instead only lists the first $$ for each account on the new pages.

Please let me know if you can help.  I am sure it can't be too difficult.
Peter Jamieson - 24 Apr 2007 15:39 GMT
> I am sure it can't be too difficult.

Unfortunately Word does not do this "out of the box" and it isn't simple
either.

For possible approaches I suggest you look at

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

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

If you have Access, consider using Access reporting which is designed for
this kind of thing.

Peter Jamieson

>I have been trying to figure this one out for a few weeks now!
>
[quoted text clipped - 22 lines]
>
> Please let me know if you can help.  I am sure it can't be too difficult.
 
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.