Script to email specific workbooks to corresponding email addresses

[Bungu]

Hi all,

I have multiple workbooks that are created weekly which needs to be sent out to the corresponding parties. This is very time consuming and sometimes workbooks are missed in the process. There are about 100 workbooks. The workbook contains the name of the supplier and then a date is attached to it. So, the date changes weekly for the name of the workbook. The corresponding party then, fills out the workbook based on the instructions provided. I have a separate workbook with all the email addresses for the suppliers.

I want to automate emailing these workbooks with the generic instructions, to the corresponding parties using Outlook. I am fairly new to VBA and am learning it on my own. Let me know if you need additional details.

 

[Bungu]

Oops..sorry about that. The workbooks are pulled from an existing macro. This pulls the entire data from our system and then sorts it by supplier and saves each supplier its own workbook.