Macro to print to pdf and email each sheet
 

I have mastered Ron's macro on how to copy values of each sheet and email to
address in cell A1. Problem is that I have upgraded to 2007, but all of my
recipients are using 2003...i've tried to change to code to reflect but they
are unable to open now. I would like a macro to print each sheet to pdf and
then email to A1 address! I have about 20 sheets so I dont want to use the
sendmail for each.

Macro to print to pdf and email each sheet
 

Hi Kisha

Start here
http://www.rondebruin.nl/pdf.htm

There is a mail example on this page
It is easy to create a loop through all the sheets to mail all of them

If you need help post back


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kisha" wrote in message ...
I have mastered Ron's macro on how to copy values of each sheet and email to
address in cell A1. Problem is that I have upgraded to 2007, but all of my
recipients are using 2003...i've tried to change to code to reflect but they
are unable to open now. I would like a macro to print each sheet to pdf and
then email to A1 address! I have about 20 sheets so I dont want to use the
sendmail for each.