Mailing in Excel
 

Can Anyone tell me how can i send a mail through excel without attach
any file?? (just text)

Thanks for the help



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Mailing in Excel
 

Take your pick:

Option Explicit

Sub QuickMail()
ActiveWorkbook.FollowHyperlink "mailto:"

End Sub
Sub QuickMail2()
ActiveWorkbook.FollowHyperlink _
? &
& subject=somebody's mail & body=i just want to say%0d%0ahi!"
End Sub


watch the line breaks.. there should be none in the code
(and 1 in the body text :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


alguerre wrote:

Can Anyone tell me how can i send a mail through excel without attach
any file?? (just text)

Thanks for the help



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

Mailing in Excel
 

Check out
http://www.rondebruin.nl/sendmail.htm#body

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"alguerre" wrote in message ...
Can Anyone tell me how can i send a mail through excel without attach
any file?? (just text)

Thanks for the help



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/