Tom has attended:
Excel Intermediate course
Excel Advanced - For Power Users course
PowerPoint Intermediate Advanced course
VBA - Copy Pivot Tables into Body of New Email
Hi,
I have some VBA code that is designed to save a workbook as a new file, attach it and then I want to copy and paste some pivot tables from the attached file into the body of the new email. Is there any smart way of doing this?
Thanks!
Tom
RE: VBA - Copy Pivot Tables into Body of New Email
Hi Tom,
Thank you for the forum question.
Excel VBA can do everything (almost).
I do not know the level of your VBA knowledge, but it is not straight forward. You will need to understand Variables, the reference Libraries, Outlook VBA, FileSystem object and much more.
I found a good video on Youtube which can help you.
https://www.google.com/search?q=excel +vba+copy+and+paste+pivot+table+to+email+body&spell=1&sa=X&ved=0ahUKEwiTg5vzrsjhAhWo3eAKHaZPC9YQBQgrKAA&biw=1275&bih=605#kpvalbx=1
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
