mailto syntax for text to display

[Jason Falzon]

I am successfully using the following: -


Private Sub lblFeedback_Click()
Link = "mailto:[email protected]?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?

 

[aflatoon]

If you are actually using Outlook, then you should be able to put th
display name in for existing contacts. You can also use something like:
mailto: Joe Public <[email protected]>
to get both a display name and address (again, with Outlook)
but I don't think you can completely obscure the email address (no
that there would be much point that I can see)

I am successfully using the following: -

Private Sub lblFeedback_Click()
Link = "mailto:[email protected]?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" wit something
similar to the text to display used in the Outlook address book?

 

[Jason Falzon]

So you are saying that I should make something like this: -

Link = "mailtoublic <[email protected]>?subject=Subject"

It's not that I want to hide it. But people will be emailing back to me with
feedback on the application that I have developed and I'd like something like
Admin to be displayed instead of my direct email. I know that it can be
easily seen but still.

Jason

 

[aflatoon]

Yep, except you should use %20 for spaces and %3c for the opening < an
%3e for the closing > so it looks like:
mailtoublic%20%[email protected]%3e?subject=Subject


So you are saying that I should make something like this: -

Link = "mailtoublic <[email protected]>?subject=Subject"

It's not that I want to hide it. But people will be emailing back to m with
feedback on the application that I have developed and I'd lik something like
Admin to be displayed instead of my direct email. I know that it ca be
easily seen but still.

Jason


------------------------------------------------------------------------

 

[Jason Falzon]

Thanks a billion for the help, but I had realised that although it works, it
will be more than useless as this tool will circulate inside the company and
since my email address is in the address book, Outlook will immediately
change to the default display as text.

However thanks as I have learnt something for the future.

Jason