Hi all,

I have 8 pivot tables on one worksheet. All 8 pivot tables
are based on the same list. They all represent information
for 8 managers. I want to have a button to the right of
each table that when pressed sends an HTML version of the
table to that manager using e-mail. Because all tables are
based on the same info I don't one manger to know the
other info, hence HTML.

Does anyone know how I could program this?

Hi Simon

My SendMail Add-in have this option and I have Examples on my site
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Simon" wrote in message ...
Hi all,

I have 8 pivot tables on one worksheet. All 8 pivot tables
are based on the same list. They all represent information
for 8 managers. I want to have a button to the right of
each table that when pressed sends an HTML version of the
table to that manager using e-mail. Because all tables are
based on the same info I don't one manger to know the
other info, hence HTML.

Does anyone know how I could program this?