Macro to send an email

[humacdeep]

Hi,

I have a Spread Sheet with Data & Pivot Table. I have recorded the Macro to generate Pivot table.

I used the below code to send an email, however when I try to send it is coping only data with out format.

Please Login or Register  to view this content.

I am looking for a code to send an email of the Pivots in sample sheet in the body of the email. Please help..

Thanks in advance for your help!!

Regards,
Humac

[arthurbr]

Some nice solutions at RonDeBruin's site

[humacdeep]

Thanks for your reply.

I dont have Admin Access to the system to install this Add in. I have tried and got an error message due to security restrictions. So if possible I request to help me in modifing the code.

Reagrds,
Humac

[arthurbr]

You can find the code at http://www.rondebruin.nl/sendmail.htm

[humacdeep]

Hi,

The code I have posted in this thread is copied from the same site, it is sending an email but not the exact Pivot Table format in the email (Just coping the data without any format).

I need your forum help in modifying the code to send the Pivots in the body of the email with out losing the Table Format.


Thanks!
Humac

[humacdeep]

Did any one get a chance to look into this?

[humacdeep]

Bump no response...