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