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?
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.)
Email Pivot Table
0
Discussion
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: 6142) May 4, '21 at 5:55 am