Question Locked

MailMerge using Office 2007 Word and Access

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a client that needs a mailmerge that:

sends a letter to each of their clients that have past due invoices. The problem I'm having is that for clients that have more than one invoice past due, the mail merge prints a separate letter for each invoice instead of including all the past due invoices on one letter.

I've googled, but no joy found.

Any suggestions would be appreciated.

2 replies

by robo_dev

http://support.microsoft.com/kb/214827

off the top of my head, I would add a field to the database that counted the number of overdue invoices per client, and then the logic would be something like:

if numb_overdue >1 then use MERGEFIELD in some extra space and the fields for the invoice numbers.....

lazy approach would be to leave the letter alone and print custom second page for multiple invoice people....

http://word.tips.net/Pages/T000287_Conditional_Processing_During_a_Mail_Merge.html

http://word.mvps.org/faqs/mailmerge/mmergeiffields.htm

This discussion is closed to new replies.