Outlook security

A

Anand

I saw the below mentioned solution given by Sue Mosher, Outlook MVP for one
of the issue. I am also facing the same problem but the context is different.
I am using Outlook 2000 SP3 as my email client and using the following code
to send emails thru excel VBA,

ActiveWorkbook.Route

How can I over come this issue?

Thanks.



This is your problem:

Set objOutlook = CreateObject("Outlook.Application")

To avoid security prompts, you must use the intrinsic Application object.
You can do this by changing the above statement to:

Set objOutlook = Application


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
S

Sue Mosher [MVP-Outlook]

See http://www.outlookcode.com/d/sec.htm for your options with regard to the "object model guard" security related to external automation.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
A

Anand

Hi Ken Slovak & Sue Mosher,

Thanks for your reply. I saw the website which you have mentioned. But I
am not sure how to get the work arounds for this as mentioned by Ken Slovak.
To be more specific let me put the entire code which I am using,

ActiveWorkbook.HasRoutingSlip = True
With ActiveWorkbook.RoutingSlip
.Delivery = xlOneAfterAnother
.Recipients = "(e-mail address removed)"
.Subject = "test"
.Message = "test"
.ReturnWhenDone = False
End With
ActiveWorkbook.Route

Basically I am using routing slip to send my excel sheet.

Thanks.
 
K

Ken Slovak - [MVP - Outlook]

The workarounds all entail using the Outlook object model instead of the
routing from Excel. I don't know if ClickYes would work with the routing, or
any of the other alternatives. That you'd have to experiment with.
 
B

Brian Tillman

Anand said:
Thanks. Let me try out 'ClickYes' option for this

Be aware that if you ever get infected with a spambot, using ClickYes will
hide its operation from you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top