Pivot table email

[m.k.johnson86]

Hey,

I was wondering if anybody knew if it is possible to write a VBA to refresh a pivot table and then email it out every day at 8am?

if it is possible what would be the coding?

Thanks for taking time to look

Cheers,

 

[m.k.johnson86]

Sorry forgot to say its excel 2007 on the Vista

 

[Trevor G]

Do you want to email the whole workbook out?

You need to look at Timer Events or from your desktop the Scheduler to schedule a task to run at a certain time of the day, but you will need to have your PC switched on.

 

[m.k.johnson86]

either or to be honest.

thanks ill google them and see what i can find out

Thanks for the guideance