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

"aflatoon" wrote:


Yep, except you should use %20 for spaces and %3c for the opening < and
%3e for the closing so it looks like:
%3e?subject=Subj ect




Jason Falzon;687650 Wrote:

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

Link = "mailto:Public ?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" wrote:


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



Jason Falzon;687530 Wrote:

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?


--
aflatoon

Regards,
A.

------------------------------------------------------------------------
aflatoon's Profile: 1501
View this thread: 'mailto syntax for text to display - The Code Cage
Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=192152)

'Microsoft Office Help - Microsoft Office Discussion - Excel VBA
Programming - Access Programming' (http://www.thecodecage.com/forumz)

.



--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: 1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=192152

http://www.thecodecage.com/forumz

.