mailto syntax for text to display

J

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?
 
J

Jason Falzon

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

Link = "mailto:public <[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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top