Mail Merging Word by excel sheet
Dear all,
I have a question about mail merging with Word. I want to send payment reminders to all my customers. So i have a excel sheet with all the information. But i need in Word a formule!!
Some debtors has more invoices outstanding. I cant send them right now one email with all the invoices. If a debtor has three outstanding invoices i have to send three email. I want to sum up the invoices if the debtors number is the same. With a total amount under all the invoices.
Can someone help me with the formule in Word, see enclosed?
I need a IF formule somewhere. I have enclosed two files. One word file for the merging. And the excel sheet.
I hope that you all can help me. if you have a question dont hesitate.
|