I am trying to export specific rows of data in excel into unique outlook emails based on client name and certain flags
In the workbook attached, one tab has client infomation and the other tab has the client name/email table and a subscription flag.
I am trying to piece togehter a macro that will export data into an email where column B on the data tabe = "Done" AND Column C on the Email Table tab = "Y".
The email should be sent to the corresponding email address based on column K on Data tab and column A on Email Table.
My question is, should I be exporting these all into unique excel files, and then run a macro to add them emails? Or, is it possible for a macro to pull this information directly into the body of an email with the correct email address?
Any guidance is appreciated.