Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Form Letter Mail Merge using field code: {Database}
I have a mailing list that I setting up (just like you would for a invoice
with many detail items). I've set up a mail merge with the field codes for the customer and set up the table using the field code {database}. I understand that it will insert a table into the mail merge. I was successful in setting up the main document & performing the merge but I cannot find anywhere, if the table {database} can spans more than 1 page. Some of the customers may have an invoice that could have details records going on multiple pages. I've notice that it will only print/display the first page and carry on with the next customer. Is there another way of doing this? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Form Letter Mail Merge using field code: {Database}
Hi ?B?anlhbg==?=,
I have a mailing list that I setting up (just like you would for a invoice with many detail items). I've set up a mail merge with the field codes for the customer and set up the table using the field code {database}. I understand that it will insert a table into the mail merge. I was successful in setting up the main document & performing the merge but I cannot find anywhere, if the table {database} can spans more than 1 page. Some of the customers may have an invoice that could have details records going on multiple pages. I've notice that it will only print/display the first page and carry on with the next customer. A DATABASE field should automatically break to another page if it reaches the end of the page. Have you inserted text etc. into something like a frame? If you start in a new document, do things behave differently? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Form Letter Mail Merge using field code: {Database}
Hi:
I should clarify. I followed the example that was posted up on the web "Group multiple items for a single condition" on Leigh Weber's website. I followed the instructions when I inserted the database field and didn't have any problems fixing the sql to put a condition break. I did try your suggestions bu merging into a new document and I get the same results. Not all items are listed in the table. By using the database field (is there a limitation?), will the table not span mulitple pages. For example, I have a customers. He has 50 items. If not all items fit on the first page, will it not continue on the next page? and then break once the condition is satisified in the sql? Below is my code. Any help on this would be appreciated. { MERGEFIELD APPROVAL_HOLDER } { MERGEFIELD COMPANY_NAME } { MERGEFIELD BUILDING_NAME } { MERGEFIELD DELIVERY_ADDRESS } { MERGEFIELD MUNICIPALITY }, {MERGEFIELD PROVINCE_CODE} { MERGEFIELD POSTAL_CODE } { DATABASE \d "H:\\wur UAT Testing\\WUR EMSP Access Mailout\\WUR EMSP.mdb" \c "DSN=MailMerge;DBQ=H:\\wur UAT Testing\\WUR EMSP Access Mailout\\WUR EMSP.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" \s "SELECT `APV_ID` as `LICENCE NO`, `MANUAL_APV_NUMBER` as `INTERIM LICENCE NO`, `SOURCE`, `LOCATION`, `DISTRICT` FROM `tWURAddressesLocation` WHERE `approval holder` = '{ MERGEFIELD APPROVAL_HOLDER }'" \t "15" \l "23" \b "191" \h } Otherwise, I think it works great, but not great if not all items will not be display for a customer. Janet "Cindy M -WordMVP-" wrote: Hi ?B?anlhbg==?=, I have a mailing list that I setting up (just like you would for a invoice with many detail items). I've set up a mail merge with the field codes for the customer and set up the table using the field code {database}. I understand that it will insert a table into the mail merge. I was successful in setting up the main document & performing the merge but I cannot find anywhere, if the table {database} can spans more than 1 page. Some of the customers may have an invoice that could have details records going on multiple pages. I've notice that it will only print/display the first page and carry on with the next customer. A DATABASE field should automatically break to another page if it reaches the end of the page. Have you inserted text etc. into something like a frame? If you start in a new document, do things behave differently? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Form Letter Mail Merge using field code: {Database}
Hi ?B?SmFuZXQ=?=,
In my experience, it should work (break to another page). As a matter of fact, I was just at a customer where we have this set up and it DID work. If you view the merge results (the ABC button in the mail merge toolbar), then move to a record that you know has too many records to fit on one page. Select the Database field and press F9 to force the update (this is all still in the main merge document), does the table break to another page? Or does it still stop at the end of the page? If you click in the table, do you see any kind of box around it? If you check in Table/Table Properties is it formatted with any textflow / wrap? I should clarify. I followed the example that was posted up on the web "Group multiple items for a single condition" on Leigh Weber's website. I followed the instructions when I inserted the database field and didn't have any problems fixing the sql to put a condition break. I did try your suggestions bu merging into a new document and I get the same results. Not all items are listed in the table. By using the database field (is there a limitation?), will the table not span mulitple pages. For example, I have a customers. He has 50 items. If not all items fit on the first page, will it not continue on the next page? and then break once the condition is satisified in the sql? Below is my code. Any help on this would be appreciated. { MERGEFIELD APPROVAL_HOLDER } { MERGEFIELD COMPANY_NAME } { MERGEFIELD BUILDING_NAME } { MERGEFIELD DELIVERY_ADDRESS } { MERGEFIELD MUNICIPALITY }, {MERGEFIELD PROVINCE_CODE} { MERGEFIELD POSTAL_CODE } { DATABASE \d "H:\\wur UAT Testing\\WUR EMSP Access Mailout\\WUR EMSP.mdb" \c "DSN=MailMerge;DBQ=H:\\wur UAT Testing\\WUR EMSP Access Mailout\\WUR EMSP.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" \s "SELECT `APV_ID` as `LICENCE NO`, `MANUAL_APV_NUMBER` as `INTERIM LICENCE NO`, `SOURCE`, `LOCATION`, `DISTRICT` FROM `tWURAddressesLocation` WHERE `approval holder` = '{ MERGEFIELD APPROVAL_HOLDER }'" \t "15" \l "23" \b "191" \h } Otherwise, I think it works great, but not great if not all items will not be display for a customer. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Form Letter Mail Merge using field code: {Database}
Hi Cindy:
I've tried your suggestions below and nothing works. I display the records that has the many records and press F9 to force the update and the table does not break to another page. It stops at the end of the page. I did click in the table to view the table properties. I could not find anything regarding textflow/wrap. There is a row wrap which is already check on. By the way, I'm using Access 2000 & Word 2000. Should I try and re-create the main document merge? Thank your for your help. Janet "Cindy M -WordMVP-" wrote: Hi ?B?SmFuZXQ=?=, In my experience, it should work (break to another page). As a matter of fact, I was just at a customer where we have this set up and it DID work. If you view the merge results (the ABC button in the mail merge toolbar), then move to a record that you know has too many records to fit on one page. Select the Database field and press F9 to force the update (this is all still in the main merge document), does the table break to another page? Or does it still stop at the end of the page? If you click in the table, do you see any kind of box around it? If you check in Table/Table Properties is it formatted with any textflow / wrap? I should clarify. I followed the example that was posted up on the web "Group multiple items for a single condition" on Leigh Weber's website. I followed the instructions when I inserted the database field and didn't have any problems fixing the sql to put a condition break. I did try your suggestions bu merging into a new document and I get the same results. Not all items are listed in the table. By using the database field (is there a limitation?), will the table not span mulitple pages. For example, I have a customers. He has 50 items. If not all items fit on the first page, will it not continue on the next page? and then break once the condition is satisified in the sql? Below is my code. Any help on this would be appreciated. { MERGEFIELD APPROVAL_HOLDER } { MERGEFIELD COMPANY_NAME } { MERGEFIELD BUILDING_NAME } { MERGEFIELD DELIVERY_ADDRESS } { MERGEFIELD MUNICIPALITY }, {MERGEFIELD PROVINCE_CODE} { MERGEFIELD POSTAL_CODE } { DATABASE \d "H:\\wur UAT Testing\\WUR EMSP Access Mailout\\WUR EMSP.mdb" \c "DSN=MailMerge;DBQ=H:\\wur UAT Testing\\WUR EMSP Access Mailout\\WUR EMSP.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" \s "SELECT `APV_ID` as `LICENCE NO`, `MANUAL_APV_NUMBER` as `INTERIM LICENCE NO`, `SOURCE`, `LOCATION`, `DISTRICT` FROM `tWURAddressesLocation` WHERE `approval holder` = '{ MERGEFIELD APPROVAL_HOLDER }'" \t "15" \l "23" \b "191" \h } Otherwise, I think it works great, but not great if not all items will not be display for a customer. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Form Letter Mail Merge using field code: {Database}
Hi ?B?SmFuZXQ=?=,
I've tried your suggestions below and nothing works. I display the records that has the many records and press F9 to force the update and the table does not break to another page. It stops at the end of the page. I did click in the table to view the table properties. I could not find anything regarding textflow/wrap. There is a row wrap which is already check on. By the way, I'm using Access 2000 & Word 2000. Should I try and re-create the main document merge? Word 2000, hmmm. Nothing occurs to me right off-hand. One other thing, quickly, before you test in a new document: If you remove the table (field) and type a lot of text (copy/paste will do), does that break to another page? (Just want to make sure it's only the table, and not something else). Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert to Symbols | Microsoft Word Help | |||
Help to merge Image (Doug Robins?) | Mailmerge | |||
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe | Microsoft Word Help | |||
Mail Merge - DataPerfect database to Word | Mailmerge | |||
capitalization of the first letter in a mail merge field + excepti | Mailmerge |