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?

--
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" wrote in message news
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" wrote in message ...
I read the information he
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 Worksheet
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(xlCellTypeConst ants)



'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