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