Reply
 
Thread Tools Display Modes
  #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


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge with Multiple Rows

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/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

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

and at:

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


--
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

"rodger" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rodger Rodger is offline
external usenet poster
 
Posts: 8
Default Mail Merge with Multiple Rows

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


"Doug Robbins - Word MVP" wrote in message
...
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/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

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

and at:

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


--
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

"rodger" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? CalMac Captain Tables 1 May 19th 06 03:27 PM
mail merging multiple columns with varying number of rows troll_mage Mailmerge 1 November 10th 05 06:42 PM
mail merge that can't sort because rows are table headings Pat Evans Microsoft Word Help 4 June 10th 05 02:11 PM
Mail Merge with duplicate rows of data Jeans Mailmerge 2 June 2nd 05 05:32 PM
Mail Merge could create new rows in a existing table danielgatley Mailmerge 1 April 18th 05 02:29 PM


All times are GMT +1. The time now is 11:54 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"