I am trying to give a user the ability to comment via email. They click on my
email address and Outlook will appear with my email address on the "To:" line.
Here is the following code that I am using:
Private Sub Label35_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
ThisWorkbook.FollowHyperlink "mailto:" & Me.Label35.Caption
End Sub
This works when I have Outlook open. However, when Outlook is closed and then
opened and text is entered into the body of the email; I get an error. "A
fatal error has occured in Outlook. The data in your envelope has been lost,
but the document is still available." I do not know how to fix this error.
Also, instead of a Double Click Event, I would like just a Click Event. I
tried changing DblClick to Click, but something is wrong with the declaration.
Any ideas?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1