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.
|