Macro to email attachments (excel file/s), copy body and lookup email address from a list
I am very new to macros and need your help to do some automation.
In an excel sheet (Site_Codes), I have a list of site codes and site manager's email address. In another worksheet (Subject) same workbook, I have subject line in a row and body of the email in the rows underneath. I have to regularly send managers their invoices (excel attachments). All files are saved as site codes. I want a macro to only compose emails (not outlook), copy subject line and body from the Subject sheet, lookup the right email address from the Site_Codes sheet and attach corresponding invoice from the specified location. I want macro to only compose/draft emails and I will send them out.
Thanks in advance.
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