When I put the following code in "after update" I get the run time error 429. ActiveX componet cannot create object.
Any suggestions would be greatly appeciated!
Public Sub SendMessage()
> Dim objOutlook As Outlook.Application
> Dim objOutlookMsg As Outlook.MailItem
> Dim objOutlookRecip As Outlook.Recipient
> Dim SafeItem
>
> Set SafeItem = CreateObject("Redemption.SafeMailItem")
> ' create the Outlook session
> Set objOutlook = CreateObject("Outlook.Application")
> ' create the Message
> Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
> SafeItem.Item = objOutlookMsg
> With SafeItem
> .Recipients.Add "MyRecipient<my_address@tesco.net>"
> .Subject = "Testing"
> .Body = "This is a test of Redemption"
> '.Display
> .Save
> .Send
> End With
> Set objOutlookMsg = Nothing
> Set objOutlookMsg = Nothing
> Set SafeItem = Nothing
>
> End Sub
Any suggestions would be greatly appeciated!
Public Sub SendMessage()
> Dim objOutlook As Outlook.Application
> Dim objOutlookMsg As Outlook.MailItem
> Dim objOutlookRecip As Outlook.Recipient
> Dim SafeItem
>
> Set SafeItem = CreateObject("Redemption.SafeMailItem")
> ' create the Outlook session
> Set objOutlook = CreateObject("Outlook.Application")
> ' create the Message
> Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
> SafeItem.Item = objOutlookMsg
> With SafeItem
> .Recipients.Add "MyRecipient<my_address@tesco.net>"
> .Subject = "Testing"
> .Body = "This is a test of Redemption"
> '.Display
> .Save
> .Send
> End With
> Set objOutlookMsg = Nothing
> Set objOutlookMsg = Nothing
> Set SafeItem = Nothing
>
> End Sub