Multiple Sheets from workbook as attachment of email

Hi,

I have a workbook where i send emails by using an existing VBA code to attach sheet from column B, rest of data like To, CC subject body from Masterlist sheet.

I am aiming to attach multiple sheets in an email. Those sheets are in column K and L along with existing column B sheets. Code should renames the files to corresponding name in column N, attach to email create components of email.

In Body of email where it says total commission = XX, after that I am trying to add a screenshot of report from summary sheet where row 1 & 2 are headers and for each sales rep. respective row will be pasted with header. Either as picture or table with proper formatting.

Thanks,

That worked like a charm for attaching multiple sheets. However, i tried the link and followed the instructions but am not able to attach the screenshot from summary sheet as desired.

When i execute the code it gives long html codes instead of screenshot in email body.

Please Login or Register  to view this content.