Home |
Search |
Today's Posts |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Form Letter Mail Merge using field code: {Database}
Hi Cindy,
I wanted to let you know I solved my problem. I recreated the "Insert Database" portion again in my merge main document. What I wasn't doing right is when I get to the "Insert Data" Screen. I had Insert Records set to "All" but I did not check the box "Insert data as field" As soon as I did this, all the records shows up on the table. I think if there was more information & examples regarding how to use the "Insert Database" field, I would have been able to resolve my problem earlier. I would like to thank you for your help. Janet "Janet" wrote: Hi Cindy: I think I know what the problems is ... its my sql statement in the Database field. I modified it to include the "Where" clause. I notice that I put a quote (') around the Merge field code '{ MERGEFIELD APPROVAL_HOLDER }' and the sql doesn't know what I want. My problem now is I don't know how to reference the {MERGEFIELD APPROVAL_HOLDER}. I notice when I insert the "Database field" that it put (`) around the fields. I tried this for the merge field and now I get "Unable to open datasource". What am I doing wrong? Merge Code is below Thank you for your help. Janet { 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 } "Cindy M -WordMVP-" wrote: 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 :-) |
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 |