Re: Possible to Disable Object Model Guard?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Good site Sue, unfortunately I still get an error...

Error says:
'The SendUsing configuration value is invalid'

This is the line that causes the error:
objMessage.Send

The Object Model Guard pops up again if I change the line to this:
..Send


Below is my full code:
Sub Send_Files()
'Working in 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim sh As Work***
Dim cell As Range, FileCell As Range, rng As Range

With Application
.EnableEvents = False
.ScreenUpdating = False
End With


Set sh = Sheets("Send Emails")


Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon

Set objMessage = CreateObject("CDO.Message")
'Set objMessage = CreateObject("CDO.Message")

For Each cell In sh.Columns("B").Cells.SpecialCells(xlCellTypeConstants)



'Enter the file names in the C:Z column in each row
Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")



If cell.Value Like "?*@?*.?*" And _
Application.WorksheetFunction.CountA(rng) > 0 Then
Set OutMail = OutApp.CreateItem(0)



With OutMail
objMessage.Subject = "Example CDO Message"
objMessage.From = "ryguy7272@xxxxxxxxxxx"
objMessage.To = cell.Value
objMessage.TextBody = "This is some sample message text."


.To = cell.Value
.Subject = "Sales Reps. Data"
.Body = "Hi " & cell.Offset(0, -1).Value

For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Value
End If
End If
Next FileCell


objMessage.Send

End With

Set OutMail = Nothing
End If
Next cell



Set OutApp = Nothing
Set objCDOMail = Nothing

With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub

I am receptive to ideas...

Thanks to all who looked.
Ryan--

--
RyGuy


"Sue Mosher [MVP-Outlook]" wrote:

I don't do CDO for Windows programming. The page at http://www.paulsadowski.com/WSH/cdo.htm is an excellent reference and shows how you need to provide configuration information about the SMTP server to be used for sending the message.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"ryguy7272" <ryguy7272@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:69E43626-55FC-466B-A8EC-12DE2E5E625A@xxxxxxxxxxxxxxxx
I did some editing; still get errors.
Error occurs here:
Set .Configuration = cdoConfig


Entire macro:
Sub Send_Files()

Dim OutApp As Object
Dim OutMail As Object
Dim sh As Work***
Dim cell As Range, FileCell As Range, rng As Range




With Application
.EnableEvents = False
.ScreenUpdating = False
End With



Set sh = Sheets("Send Emails")

Set myMail = CreateObject("CDO.Message")
Set objMessage = CreateObject("CDO.Message")



For Each cell In sh.Columns("B").Cells.SpecialCells(xlCellTypeConstants)


Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")


If cell.Value Like "?*@?*.?*" And _
Application.WorksheetFunction.CountA(rng) > 0 Then




With cdoMessage
Set .Configuration = cdoConfig
'.From = ""
.To = cell.Value
.Subject = "Sample CDO Message"
.TextBody = "Hi " & cell.Offset(0, -1).Value



For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Value
End If
End If
Next FileCell

.Send
End With


Set objMessage = Nothing
Set myMail = Nothing

End If

Next cell

With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub

I've hit a wall again. I've seen your name all over the Outlook-Programming
DGs. and I'll bet anything you know what to do from here Sue. I want to
learn this, so please tell me what to do to resolve the problem, or please
refer me to a resource on the web that explains what to do.

Regards,
Ryan---

--
RyGuy


"Sue Mosher [MVP-Outlook]" wrote:

Which statement is raising the error? Why are you coding both the Outlook.MailItem, which you know will raise security prompts, and the CDO.Message, which won't?

"ryguy7272" <ryguy7272@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D6DB44B3-4FEC-4D68-AF58-0D0DC4A3548E@xxxxxxxxxxxxxxxx
Thanks for the follow up Sue. I guess I still don't understand what makes
this work or not work. Not, I am using this code:

With OutMail
objMessage.To = cell.Value
objMessage.Subject = "Sales Reps. Data"
objMessage.Body = "Sales Reps. Data"

.To = cell.Value
.Subject = "Sales Reps. Data"
.Body = "Hi " & cell.Offset(0, -1).Value

For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Value
End If
End If
Next FileCell

objMessage.Send
End With

When code runs I get this:
Object doesn't support this property or method.

What am I doing wrong. If there is something specific that I need to know,
please tell me. I don't know much about Outlook at all.

Regards,
Ryan---




--
RyGuy


"Sue Mosher [MVP-Outlook]" wrote:

If you read that page, you'd know that the object model guard can't be disabled except by an Exchange administrator.

Your code creates a CDO.Message object but never sends it. That's an approach you can take, instead of using Outlook objects and getting prompts.


"ryguy7272" <ryguy7272@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5F5E7688-864B-4C15-B313-EB4B71B61DAA@xxxxxxxxxxxxxxxx
I read the information here:
http://www.outlookcode.com/article.aspx?id=52

It is very interesting. Maybe I missed something, but I still can't seem to
disable the Outlook Object Model Guard. I am sending multiple emails from
Excel. code is below:
Sub Send_Files()
'Working in 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim sh As Work***
Dim cell As Range, FileCell As Range, rng As Range




With Application
.EnableEvents = False
.ScreenUpdating = False
End With



Set sh = Sheets("Send Emails")


Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon

Set objMessage = CreateObject("CDO.Message")


For Each cell In sh.Columns("B").Cells.SpecialCells(xlCellTypeConstants)



'Enter the file names in the C:Z column in each row
Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")



If cell.Value Like "?*@?*.?*" And _
Application.WorksheetFunction.CountA(rng) > 0 Then
Set OutMail = OutApp.CreateItem(0)



With OutMail
objMailItem.To = cell.Value
'.To = cell.Value
.Subject = "Sales Reps. Data"
.Body = "Hi " & cell.Offset(0, -1).Value

For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Value
End If
End If
Next FileCell

.Send 'Or use Display
End With



Set OutMail = Nothing
End If
Next cell



Set OutApp = Nothing


With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub


Is there any way to disable that Model Guard with code?

Thanks,
Ryan---


--
RyGuy



.

Quantcast