Hi there,
I'm working on a macro to format some payment remittance information and automatically notify vendors that a payment has been remitted.
So far I'm able to get the remittance information in the following format:
I'm struggling with now getting the macro to cycle through each unique vendor and create an e-mail including that vendor's specific payment information.
I don't want an e-mail for each invoice, just one per vendor. Since there could be a variable number of vendors each with a variable number of payments, I was hoping to create an e-mail for each vendor and summarizing the information as in the following examples to the Hydro and Telephone Vendors:
The key piece I'm looking for is the ability to create one e-mail per vendor and populate the body of the e-mail with the cell value from the C Column (for the total remittance amount) and then the table in columns D & E to detail the amount for each invoice.
Any help is greatly appreciated!
Thanks very much.
I'm working on a macro to format some payment remittance information and automatically notify vendors that a payment has been remitted.
So far I'm able to get the remittance information in the following format:
I'm struggling with now getting the macro to cycle through each unique vendor and create an e-mail including that vendor's specific payment information.
I don't want an e-mail for each invoice, just one per vendor. Since there could be a variable number of vendors each with a variable number of payments, I was hoping to create an e-mail for each vendor and summarizing the information as in the following examples to the Hydro and Telephone Vendors:
The key piece I'm looking for is the ability to create one e-mail per vendor and populate the body of the e-mail with the cell value from the C Column (for the total remittance amount) and then the table in columns D & E to detail the amount for each invoice.
Any help is greatly appreciated!
Thanks very much.
