statement+ letter

[Acubed]

I have a client that wants to print a Past Due letter for all statements
that are past 30 days normally this is done through crystal reports to just
print a statement. However he wants a letter on the top half and a half page
statement on the bottom half the top half is no problem it's just a mail
merge from a query of those that are past due the second is my problem how
do I make word go through the records of the second query that are connected
to each record of the first? and to place one record per a line and not one
record per page?

if anyone has a sample of an invoice or statement that retrieves the
information from a database that I could use as a starting point it would be
very helpful.

many thanks in advance
Sam

 

[Doug Robbins - Word MVP]

I would do it all with Access

Word simply isn't designed to handle one-to-many. There are three
basic ways to approach the problem, none of them particular easy for
users to implement. They're described in the "Multiple items per condition"
topic of the "Special merges"
section of fellow MVP, Cindy Meister's webside at:

http://homepage.swissonline.ch/cindymeister

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP