Hi,

I have a hyperlink (email address) in a user form, but what I would
like to do is when the link is clicked, the file to get attached to an
email.

Here is the code I presently have, where by clicking will open an email
window and the file wil remain open.

Private Sub lblMail_Click()
Link = "
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Unload Me

Exit Sub

End Sub


Private Sub UserForm_Click()


End Sub

Appreciate your help.

Mike


--
caddy
------------------------------------------------------------------------
caddy's Profile: http://www.excelforum.com/member.php...o&userid=31858
View this thread: http://www.excelforum.com/showthread...hreadid=515843