print macro and email

[Guest]

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

 

[Guest]

You'll find most of what you're looking for at
http://www.dicks-clicks.com

 

[Ron de Bruin]

Hi Ken

Which excel version do you use ?

 

[Guest]

Ron
I use 2003 but I want this to be compatible with 2000.
Thanks
KL

 

[Ron de Bruin]

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