ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   mailto syntax for text to display (https://www.excelbanter.com/excel-discussion-misc-queries/260415-mailto-syntax-text-display.html)

Jason Falzon[_2_]

mailto syntax for text to display
 
I am successfully using the following: -


Private Sub lblFeedback_Click()
Link = ?subject=Subject"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub

Is it possible to hide the email address and put e.g. "ADMIN" with something
similar to the text to display used in the Outlook address book?



ozgrid.com

mailto syntax for text to display
 
Not that I know of. Why not protect the VBAProject?
http://www.ozgrid.com/VBA/protect-vba-code.htm



--
Regards
Dave Hawley
www.ozgrid.com


"Jason Falzon" wrote in message
...
I am successfully using the following: -


Private Sub lblFeedback_Click()
Link = ?subject=Subject"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub

Is it possible to hide the email address and put e.g. "ADMIN" with
something
similar to the text to display used in the Outlook address book?





All times are GMT +1. The time now is 10:45 AM.

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