email excel file or worksheet as an attachment to multiple email addresses
I am seeking code sample or tips to help with the following:
Workbook 1 contains a organization and email addresses for the organization.
Workbook2 contains a separate worksheet (worksheet name would be AF, Baghdad, etc) for each organization and I have a folder on my desktop that contains files (file names would be AF.xls, Baghdad.xls, etc) for each organization.
What I am trying to do is send an email to each address in workbook 1 that contains the worksheet or file for that organization - file name or worksheet name matches the org name in workbook 1.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1