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


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: http://www.thecodecage.com/forumz/sh...d.php?t=192152

http://www.thecodecage.com/forumz