mdasifiqbal
12-11-2021, 02:06 AM
Dear Friend,
I have been using a VBA which automates my outstanding statement to identify different customers and create a new .xls file for each customer and I use a different VBA which automates bulk e-mail through outlook by sending each customer their outstanding statement as attachment.
What i want to do differently is that the VBA should open the attachment and send the content in the .xls file on the mail body to each individual recipient.
Does anyone has a solution to this. or want to give it a try
Thanks in advance
Asif
I have been using a VBA which automates my outstanding statement to identify different customers and create a new .xls file for each customer and I use a different VBA which automates bulk e-mail through outlook by sending each customer their outstanding statement as attachment.
What i want to do differently is that the VBA should open the attachment and send the content in the .xls file on the mail body to each individual recipient.
Does anyone has a solution to this. or want to give it a try
Thanks in advance
Asif