Send Outlook Msg form Access

[Debbie]

Hello,
I have Access 2003 and I'm trying to create an Outlook email from Access.
I have the following code:

Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim MsgText As String

'Create the Outlook session
Set objOutlook = CreateObject("Outlook.Application")

'Create message
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)


I get a run time error 429 "ActiveX component can't create object". Can
anyone give me a hint as to what I'm doing wroing? Thanks, I have exhausted
all my resources!
Debbie

 

[Sue Mosher [MVP-Outlook]]

DO you have an anti-virus application running with an email-related component
that blocks scripting? That would block CreateObject.

 

[Debbie]

Sue,
I do have Norton AntiVirus but I don't see anything in the options menu that
talks about scripting. Would it be called anything else? Could there be
something in Outlook I need to change? I looked there but nothing looked
like the cuprit. Any other thoughts? Thanks,
Debbie

 

[Sue Mosher [MVP-Outlook]]

That's almost certainly it. I don't have NAV installed here, so I can't tell
you exactly where to find the setting. You may need to use Help or check
Symantec's web site.