Pivot Table Row selection in VBA

I'm not a VBA expert and I've been looking and looking and trying multiple codes without success for the past few days...

I'm wanting to copy all data from my pivot table expect for the last Column, "Clients" and paste it as html in an email using a caller called function. I have been able to get my data, but lose all the pivot table design formatting when using the below:

Please Login or Register  to view this content.

and my paste code is as follows:

Please Login or Register  to view this content.

I've also tried the .pivotfields("clients").orientation=xlhidden but didn't work for me. It only copied blank data and also hid that Column from my actual source pivot table.


Any help would be great as I am at wits end!!!

Still trying to figure this out... driving me crazy!