Email without ALLOW message

[toobig]

I need some help on figuring out how to send an email through Excel without getting the Microsoft Security message that asks you to Allow the message to be sent. Here is what I have now. Any help yould be greatly appreciated. Thanks...

Sub Mail_ActiveSheet()

Dim strDate As String
Dim Site As String
Dim Project As String


Site = Sheets("CDLEmail").Range("A6").Value
Project = Sheets("CDLEmail").Range("A8").Value
strDate = Format(Date, "dd-mm-yy") & " " & Format(Time, "h-mm-ss")

ActiveSheet.Copy
Application.DisplayAlerts = False

ActiveWorkbook.SendMail "email.com", _
"CDL Maintenance for " & Site & " " & Project & " " & strDate
ActiveWorkbook.Close savechanges:=False
Application.DisplayAlerts = True

End Sub

 

[mole999]

I don't have the routine to hand that i use, though bear in mind, if your using outlook, it has to be started to send the mail

 

[Smitty]

Welcome to the Board!

You can use Outlook Redemption.

It's free and easy.

HTH,

 

[Michael M]

I believe this is caused by your anti virus software.
If it's anything like mine, you will have to go to the Anti virus tools and adjust your Email security settings.

 

[Smitty]

I believe this is caused by your anti virus software.
If it's anything like mine, you will have to go to the Anti virus tools and adjust your Email security settings.

Actually, it's by design: http://msdn.microsoft.com/en-us/library/aa168346(office.11).aspx

 

[Michael M]

Hi Smitty
Thanks for pointing that out, I stand corrected.....as usual.... LOL !
I love having big brother keeping an eye on what I do.

 

[Smitty]

Not big brother at all (at least I didn't intend it that way). I just spent a lot of time going through this one on several projects.

 

[Michael M]

my apologies Smitty, I didn't mean you, I was referring to Big Brother Microsoft !!!

 

[Smitty]

my apologies Smitty, I didn't mean you, I was referring to Big Brother Microsoft !!!

Gotcha

 

[toobig]

Thanks for all the help. I ended up going another route which worked better for what I need to do.I thought I might be able to get away with less code but the long ways is usually more bullet proof in the end.