View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Photos in excel and email

Hi alvin

On that page you can read this

If you use Office 2002 or 2003 see this KB article.
How to Send a Range of Cells Using VBA. (with shapes)
http://support.microsoft.com/default...b;en-us;816644






--
Regards Ron de Bruin
http://www.rondebruin.nl



"Alvin Hansen" wrote in message ...
Hi ron
I use teh one you have to send a mail where the shett go into the body
of the mail -- but not the pictures i have trye with several sheets and names

do i something wrong here?

regards alvin


"Ron de Bruin" skrev:

Hi Alvin

If you use Excel 2002 or 2003 you can do it (there is a link in the Body examples)

For charts I add a example yesterday on my site to send it as a picture (2000 and higher)
http://www.rondebruin.nl/sendmail.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Alvin Hansen" wrote in message
...
Hi
I have a macro there send a email made in html
so far so good its working. I take the values from a sheet in excel
but in this sheet there are also a picture, and in a html code the pictures
are a link to a souce file, is there someway to take the picture from the
sheet and put it in the html code whitout have the photo as a source file?
If i make a email in outlook i can put a picture into the email so maybe also
when i create this email from excel ??

Hope someone knows somthing about this

Regards alvin