Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Email Pivot Table


Hi! I have been using VBA to email a range of cells into the outlook body. However I want to copy and paste a Pivot Table into the Body. By this I mean as if I paste it into the body in HTML (like ctrl+v) and not an image (which I currently use, but that incorporates a set range and is not dynamic). I have tried to incorporate RoindeBruin's code, but no luck. Can someone please help?



Ron de Bruin's code is the gold standard for emailing Excel. It should adapt easily to your requirement - if you want a hypotheical answer. For a practical one, please modify your question. Attach a workbook containing your current version of Ron de Bruin's code and an example of a pivot table you want to email. From the code we will also know by which method you send the mail.
Variatus (rep: 4889) May 3, '21 at 8:19 pm
As Variatus says, we need to see a file really. I just tried Ron de Bruin's Function RangetoHTML(Rng As Range) with a simple pivot table and it worked fine with Outlook 365.
John_Ru (rep: 4937) May 4, '21 at 5:55 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login