Outlook security

[Guest]

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

 

[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

 

[Ken Slovak - [MVP - Outlook]]

That method will always trip the security, especially in Outlook 2000 SP3.
You have to use one of the workarounds for automating the Outlook object
model securely to avoid that:.

http://www.outlookcode.com/d/sec.htm

 

[Guest]

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.

 

[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.

 

[Guest]

Thanks. Let me try out 'ClickYes' option for this

 

[Brian Tillman]

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.