View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
aflatoon[_5_] aflatoon[_5_] is offline
external usenet poster
 
Posts: 1
Default mailto syntax for text to display


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