Pivot table to Outlook

sarathmenon

New Member
Joined
Aug 18, 2021
Messages
2
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hello All
I am new to VBA programming. I have an Excel workbook with two worksheets - one containing raw data and the other containing a pivot table and corresponding slicers for it.
My requirement is to use VBA to dynamically choose particular options in the slicers and copy the resultant pivot table into the body of an Outlook mail. The pivot table has a few hidden columns in between, so I would like to copy only the visible columns.
I found a solution online which helps me copy the pivot table if the slicer options are chosen manually. But the issue with that was that only the columns up till the first hidden column were chosen. So I wasn't able to copy the rest of the visible columns which came after.
Could someone please help me with this?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,223,250
Messages
6,171,036
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top