ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Email Text Message (https://www.excelbanter.com/excel-programming/285661-email-text-message.html)

Steve[_53_]

Email Text Message
 
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?

Dick Kusleika[_3_]

Email Text Message
 
Steve

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

Dim mylink As String

mylink =
?subject=This%20is%20a%20test&body=Hello "

ThisWorkbook.FollowHyperlink mylink

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.



"Steve" wrote in message
...
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?





All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com