Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
Email addresses in Excel need to format for mass email | Excel Worksheet Functions | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
working on excel document in email saved changes in email not in . | Excel Discussion (Misc queries) | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |