Email Text Message

S

Steve

I want to send a text message in Excel using VB. The mail
program is Netscape. I have figured out how to email a
workbook, but I can not figure out how to just send a text
message, without attaching a workbook. Can anyone help?
 
D

Dick Kusleika

Steve

You can create a mailto hyperlink and execute that. For instance

Dim mylink As String

mylink =
"mailto:[email protected]?subject=This%20is%20a%20test&body=Hello"

ThisWorkbook.FollowHyperlink mylink
 
Top