Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Guys
I'm running Office 2003 and need to automate the sending of a notification e-mail to myself when ever my code receives and error. I used the following code but this screen keeps popping up saying: A program is trying to automatically send e-mail on your behalf. Do you want to allow this?... I think it's the "Outlook - Object Model Guardian" requesting this confirmation. Is there any work around as this e-mail needs to go out without any human interaction? Private Sub SendErrorEmail() Dim objOutlook As New Outlook.Application Dim objMail As MailItem Dim strMessage As String Set objOutlook = New Outlook.Application Set objMail = objOutlook.CreateItem(olMailItem) strMessage = "Jan," & Chr(13) & Chr(13) strMessage = strMessage & "This is just a test." & Chr(13) & Chr(13) strMessage = strMessage & "Cheers. Jan" With objMail .To = " .Subject = "Testing" .Body = strMessage .Display .Send End With Set objMail = Nothing Set objOutlook = Nothing End Sub Please help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Chart Object Model | Excel Programming | |||
Excel object model | Excel Programming | |||
Subtotals in object model? | Excel Programming | |||
Does MS Query have an object model | Excel Programming |