MCochranKYB
New Member
- Joined
- Dec 17, 2016
- Messages
- 2
I make ACH payments to vendors once a week, and each time I have to also email each vendor a remittance detail of which invoice I paid and the amount. This is several emails and I send essentially the same email, except I update the detail to only send that vendor's information that the email is going to.
I believe there has to be an easier way to do this, possibly through a VBA code. I have all of the ACH data (invoice#, amount, vendor name, etc.) in Excel. My ultimate goal would be to send an email to each vendor individually that is listed on the worksheet, and the attachment/body of the email would send them only their data and not the full worksheet.
Does anyone have suggestions on how to go about this, or if it is even possible? I have Outlook for email and using Excel 2013.
Thanks in advance!
I believe there has to be an easier way to do this, possibly through a VBA code. I have all of the ACH data (invoice#, amount, vendor name, etc.) in Excel. My ultimate goal would be to send an email to each vendor individually that is listed on the worksheet, and the attachment/body of the email would send them only their data and not the full worksheet.
Does anyone have suggestions on how to go about this, or if it is even possible? I have Outlook for email and using Excel 2013.
Thanks in advance!