email from Pivot

[anuwers]

Dear Expert,

Here i need a VBA macro to shoot out the email from the pivot table.


Workbook has 3 sheets

Data details
Pivot Table
Email Address

Data Details which has more details
Pivot Table is brough from Data Details with Emp name in columns and Dates in Header start from start of month, lets say July month
Email Address has the email address of each Emp Name.
.
Need the macro to pull each name from the column and display the columns of each dates along with details available in pivot to respective staff.

Thanks