| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button - Macro to print to pdf, then send pdf to email. | Excel Discussion (Misc queries) | |||
| Hit email excel sheet, instead of print, how do I get normal view | Excel Discussion (Misc queries) | |||
| Macro to print and email a pdf | Excel Programming | |||
| print macro and email | Excel Programming | |||
| Vb Macro to attach sheet and send by email | Excel Programming | |||
Hybrid Mode
