save sheet as pdf and email it

T

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!
 
T

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?
 
Top