save sheet as pdf and email it
 

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!

save sheet as pdf and email it
 

--

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


"tc10" wrote in message ...
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!

save sheet as pdf and email it
 

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



--

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


"tc10" wrote in message ...
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!

save sheet as pdf and email it
 

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?

"Ron de Bruin" wrote:

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



--

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


"tc10" wrote in message ...
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!