Hi,
I have a major task in front of me (sending individual emails to over 2000 vendors, asking them to fill in a form).
I would like to try to make it simpler but my Macro level has reached its limits. I will provide you with an explanation and hopefully someone can assist.
- I have a report capturing different information such as vendor unique ID, vendor name, email address. (main Report
attached)
- I have another excel book with a standard email in a text box (email and form, sheet 1)
- I have another excel book with a standard form to send to the supplier. (email and form, sheet 2)
Email test.xlsxEmail and form.xlsxMain Report.xlsx
What I need its to have a Macro that will generate an email containing the below:
- Email text should be: the text in (email and form, sheet 1)
- Attachment should be: the form in "email and form, sheet 2" and the "supplier ID, and Name" from "main report"
the Macro should enable me to capture to generate excel sheets attachment and then to send them to the correct email address.
I appreciate your assistance with this and do not hesitate to come back to me for more details.
Bookmarks