Hi All,
My workbook has 5 different sheets and I need to copy the five sheets and paste it into 5 different mails. Preferably as HTML.
The below written code only attaches the different sheets to outlook. I need the HTML below the body of the email. Please note that my range in the sheets varies from workbook to workbook but the sheet names remain the same.
![]()
Please Login or Register to view this content.
The below written code just copies the sheets to outlook as HTML but doesn't attach the files
![]()
Please Login or Register to view this content.
How do I merge both the codes?
Here;s the sample file
https://skydrive.live.com/redir?resi...LXmsEmw9mB3qlk
Bookmarks