Hi Ron
Thanks again
I use this:
Sub Send_Range()
' Select the range of cells on the active worksheet.
Sheets("email").Range("A1:n71").Select
' Show the envelope on the ActiveWorkbook.
ActiveWorkbook.EnvelopeVisible = True
' Set the optional introduction field thats adds
' some header text to the email body. It also sets
' the To and Subject lines. Finally the message
' is sent.
With Asheets("print").MailEnvelope
.Introduction = "This is a sample worksheet."
.Item.To = "
.Item.Subject = "Booking usa"
.Item.Send
End With
But i can only get it to run if i open sheet "email" and then run the macro,
it will not work in my userform commanbutton???
Regards Alvin
"Ron de Bruin" skrev:
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