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?