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