Hi MTM,

Ron de Bruin has an extensive range of sample Outlook code at:

http://www.rondebruin.nl/sendmail.htm

which may provide with ideas for an alternative solution.


---
Regards,
Norman


"mtm4300 via OfficeKB.com" <u18572@uwe wrote in message
news:628181df79c8d@uwe...
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