Hi Mark,
What is in this letter? How much of it is common for all recipients
and how much is based on the fields? Is this something that you can
do with a MailMerge from within Word? I use/abuse this feature for so
many reports that appear to come from the database.
You can create a mail merge in word with the repeating text, then use
a query in access to provide your data file for the mail merge. As
long as the fields used in the query don't change from printing to
printing, once the mail merge has been set up, you can use a command
button on a form in access to open the mail merge document and from
there you can easily print (at least, I have been able to print odd
pages to Tray #1 and even pages to Tray #2 using Office 97 and old HP
LaserJet 3 and 4 printers). Of course, this all falls apart the
instant one piece of data is too long and causes a third page to the
report - but a simple print preview in word can identify that problem.
Or - your mail merge document can contain the letterhead formatting,
so that even if one or two "letters" end up longer than the two pages,
the next letter will automatically begin with the letterhead at the
top.
Other than that, I suppose you could create your letter head in the
report - but I'm wondering where the letter head information would go
- in the report header it will only print once at the top of the
report, in the page header it will print at the top of every page -
unless someone knows a way to get it to print on only specific pages?
Hope this offers an alternative solution!
Kim
