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 = "mailto:TREASURY@CIBCMELLON.COM"
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Unload Me

Exit Sub

End Sub


Private Sub UserForm_Click()


End Sub

Appreciate your help.

Mike