VBA Email of a predefined set of formulae based cells in a worksheet

[Mlanger575]

Hello everyone

I'm wondering if you are able to help. I am preparing an Excel workbook which largely takes a set of data for one month collected in one tab, adds this to another tab of cumulative data and then creates a sort of KPI dashboard of key highlights to send out to a user/group of users.

The emailing is not an issue, I'm struggling with the body of the email and taking my tab across with me "Report - Snap", and I'm extremely poor at the moment with using the Dim function.

Thanks
Michael

[dflak]

Is your purpose to embed a picture of Report Snap or send it as an attachment? If the later, we could arrange to save it as a PDF or JPEG and attaching that is easy. As for embedding pictures into the mail body - I'll have to research that.

Try this article: http://excel-macro.tutorialhorizon.c...k-using-excel/.