Need help with code to generate an image file of my dashboard and email it via outlook

[santnair0599]

Hello,

I have created an excel dashboard for my project. Now i want a code which can automatically convert the dashboard into an image file (jpeg, png, etc) and send this image file via outlook email to recipients. Can you please help me how to write the code for this. Appreciate your usual help.

Regards,
Santosh

[acroley1]

Here is some email code I use:

Please Login or Register  to view this content.

I'm unsure how to convert it to jpeg but if you record a macro and do just those steps related to converting to jpeg (or whatever) that may help you along. Or I guess you could write the macro to save as jpeg and then use the part of the code above that lets you add an attachment.

Here's where I got that code above from: 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm

[santnair0599]

Hello,

I have attached a dashboard which I prepared. Now I want a VBA code wherein I can click a button in this dashboard and it will automatically generate a .PDF file of this dashboard report and send this pdf file via outlook email client to the recipients. This activity needs to be automated so i would appreciate if you can help with the VB code for this.

Regards,
Santosh

[acroley1]

Try this in a module (then you can make a button and assign a macro to it on your main page):

Please Login or Register  to view this content.

[santnair0599]

Thanks a lot for the solution, it really works