View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail Merge with multiple rows for each customer?

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/cindy...r/mergfaq1.htm

http://support.microsoft.com/default...b;en-us;211303

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

Peter Jamieson

"Mary Beth McNabb" Mary Beth wrote in
message ...
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.