View Single Post
 
Old 05-27-2020, 01:48 AM
Tesla Tesla is offline Windows 7 32bit Office 2003
Advanced Beginner
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default using mailmerge to include a grouped information in a letter

Hello,
I wish to prepare a letter to debtors of my company showing them invoices not yet paid so that they can pay. The letter should contain invoice number, invoice date and amount of that invoice. I have a long list of debtors to write to and I am wondering if mail merge could help me doing so. Each debtor has a long list of invoices which I want to group on one letter sent to that debtor (one letter can have more than one page).

I tried to use the technique of "Microsoft Word Catalogue/Directory Mailmerge Tutorial", but the code provided in the tutorial is not working because I am very beginner in this kind of mail merge, I don’t know how to do it. I copied the code contained in the tutorial but I failed to connect the code with the table containing the data of my debtors.

I attach my excel document containing data I want to insert into a letter. I also attach my letter but the code is not working. If you can provide me some help I would be thankful.
Attached Files
File Type: xls list.xls (19.0 KB, 13 views)
File Type: docx letter.docx (12.0 KB, 14 views)
Reply With Quote