Mailing in Excel

[alguerre]

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

Thanks for the help

 

[keepitcool]

Take your pick:

Option Explicit

Sub QuickMail()
ActiveWorkbook.FollowHyperlink "mailto:"

End Sub
Sub QuickMail2()
ActiveWorkbook.FollowHyperlink _
"mailto:[email protected];[email protected] ? [email protected] & [email protected]
& 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 >

 

[Ron de Bruin]

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