Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm sending an email using VBA via the code listed below. Everything works
fine, but I'd like to incorporate a hyperlink in the body of the email, which I don't know how to do. Right now the link (text) is in the body of the email, but i do not know how to make it a hyperlink. Any help is appreciated. 'here's my example Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) Dim strbody As String strbody = "Please visit us at www.test.com. Thank you." 'i want the www.test.com to be a clickable hyperlink With OutMail .To = " .Subject = "test email" .Body = strbody .Display 'or use '.Send End With Thanks in advance, Chad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
email sending | Excel Programming | |||
Sending Email | Excel Programming | |||
Email sending | Excel Discussion (Misc queries) | |||
Sending an email | Excel Programming |