View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
rodger rodger is offline
external usenet poster
 
Posts: 2
Default Mail Merge with Multiple Rows

Hello all,

I have a document that I want to use for one client; however the client
could have multiple rows because they could deal with several different
banks. So all their demographic information stays the same but they might
have many different bank it could be 1 or it could be 10, I have no idea at
the time I run the merge. What I want to know is how to I run the merge
that could have many different banks?

Does this mmake sence?

Borrow Name: Mr Jones
Address: 1223 Any Street
C/S/Z My Town, XX 12345

Bank Info
1st federal my Town1 XX 12345
2nd federal my Town 2 XX 12345
3rd federal my Town 3 XX 12345

"This could go on it stop at the second one."

Credit Memo:
Text from Database

Reason for Loan:
Reason Here

Etc.

So how do I get the bank info to repeat?

I thought about using a uinion query but then I would still need to know how
many loans.

TIA,
Rodger