| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save a file from email | Excel Discussion (Misc queries) | |||
| send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
| Save & Email Macro | Excel Discussion (Misc queries) | |||
| save and email button | Excel Programming | |||
| Email/Save/Macro | Excel Worksheet Functions | |||
Linear Mode
