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?