save sheet as pdf and email it

[tc10]

I need some help with programming a macro. I'd like it do do the following.

1. Save a selected area on a sheet as an Adobe PDF
2. Have that pdf be placed as an attachment in an Outlook email
3. Let me type in the email before it sends it

Thanks!

 

[Ron de Bruin]

--

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

 

[Ron de Bruin]

Oops

I have a mail example here for 2007
http://www.rondebruin.nl/pdf.htm

If you know the code for saving the PDF if you not use 2007 look
on this page for mail code (use the Outlook object model examples)
http://www.rondebruin.nl/sendmail.htm

 

[tc10]

I'm using Excel 2003 so I'm not sure that will work...

I tried your example in your Outlook attachment examples file called
Selection Range and that works great. The problem I run into w/ that is I'd
like to have all the info in the selected range be forced into one
"printable" page on the new file that is created. Can this be done?