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.

Sae xx