|
print macro and email
I want to do a few things
I want to be able to email a chart that is in a sheet to a person using outlook. however I want to be able to type in the email address (or select it from my address book) also, is there a way I can get the "print preview" version of the chart? Thanks Ken |
print macro and email
You'll find most of what you're looking for at
http://www.dicks-clicks.com "KenL" wrote: I want to do a few things I want to be able to email a chart that is in a sheet to a person using outlook. however I want to be able to type in the email address (or select it from my address book) also, is there a way I can get the "print preview" version of the chart? Thanks Ken |
print macro and email
Hi Ken
Which excel version do you use ? -- Regards Ron de Bruin http://www.rondebruin.nl "KenL" wrote in message ... I want to do a few things I want to be able to email a chart that is in a sheet to a person using outlook. however I want to be able to type in the email address (or select it from my address book) also, is there a way I can get the "print preview" version of the chart? Thanks Ken |
print macro and email
Ron
I use 2003 but I want this to be compatible with 2000. Thanks KL "Ron de Bruin" wrote: Hi Ken Which excel version do you use ? -- Regards Ron de Bruin http://www.rondebruin.nl "KenL" wrote in message ... I want to do a few things I want to be able to email a chart that is in a sheet to a person using outlook. however I want to be able to type in the email address (or select it from my address book) also, is there a way I can get the "print preview" version of the chart? Thanks Ken |
print macro and email
Hi Ken
You can't send charts in the body with 2000 with code The only way is to send it in a file or create a picture from the chart. See my site for example code if you want to send it as a file http://www.rondebruin.nl/sendmail.htm Post back if you want to add a picture to the mail -- Regards Ron de Bruin http://www.rondebruin.nl "KenL" wrote in message ... Ron I use 2003 but I want this to be compatible with 2000. Thanks KL "Ron de Bruin" wrote: Hi Ken Which excel version do you use ? -- Regards Ron de Bruin http://www.rondebruin.nl "KenL" wrote in message ... I want to do a few things I want to be able to email a chart that is in a sheet to a person using outlook. however I want to be able to type in the email address (or select it from my address book) also, is there a way I can get the "print preview" version of the chart? Thanks Ken |
| All times are GMT +1. The time now is 02:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com