98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » VBA - Copy Pivot Tables into Body of New Email | Excel forum
VBA - Copy Pivot Tables into Body of New Email | Excel forum
Resolved · Low Priority · Version 2016
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
Thu 18 Apr 2019: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |