Mail Merge with Multiple Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rodger - 15 Mar 2007 01:16 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 15 Mar 2007 05:19 GMT

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

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

and at:

http://cornell.veplan.net/article.aspx?&a=3815

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 all,
>
[quoted text clipped - 33 lines]
> TIA,
> Rodger

Reply to this Message

Rodger - 16 Mar 2007 13:04 GMT

Doug,

Thank you. I tried this option and it became confusing for the end user to
be able to easily edit the document. I found that it was much easier to
create a temporary table and write some code to concatenate the fields I
need in one field.

Thanks again for your suggestion.

Rodger

> You are trying to perform a "multiple items per condition (=key field)"
> mailmerge which Word does not really have the ability to do:
[quoted text clipped - 49 lines]
> > TIA,
> > Rodger

Reply to this Message