SendObject rejects some e-mail names

[dick]

If it isn't one thing it's another! Now I'm getting the security warning box from OutLook (A program is attempting . . . ALLOW or DENY etc). In WLM it was a simple click on the Security option and deselect the function. But I'm going nuts trying to find how to do that in OutLook. Any guidance would be much appreciated. HELP has not lived up to it's name. Forums are tedious, Google seldom shows what I want at the top of the list etc. Grrrrrr!!!!!

[June7]

I have heard that complaint before and really don't know the solution. I am using Office 2007 and my auto email procedure runs without that warning, but I am not using SendObject.

'open Outlook, attach zip folder or file, send e-mail
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
    .BodyFormat = olFormatRichText
    .To = "email address"
    ''.cc = ""
    ''.bcc = ""
    .Subject = "text here"
    .HTMLBody = "text here"
    .Attachments.add ("path\filename")
    ''.DeleteAfterSubmit = True 'This would let Outlook send the note without storing it in your sent bin
    .send
End With

[dick]

Hmmmm. Interesting. I suppose I could do what you are doing. Somewhat
more complex but not too much. Might even work with WLM !! Is the .Subject limited to 256 characters as in SendObject?

[June7]

Probably, but never challenged it.

Google: VBA email sendobject warning
Here is one
http://www.everythingaccess.com/tuto...curity-Warning

[dick]

Tried your code but I'm missing something. Got a Compile error on both the Dim statements - undefined type. Can you provide the type definitions and where they should be placed (module, procedure)?

[June7]

You need to set a VBA reference to the Outlook library.

From the VBA editor menu Tools > References, scroll down until you find Microsoft Outlook and check it.

[dick]

That was it!!
Ran a test with my email address hard wired and it worked like a champ.

Thank you for all your guidance and the snippet of code.

Annoying that SendObject has no options to do what your code does.

I'll look for documentation on this method and see what else I can set. Right now I'm not using any attachments but setting a "From:" would be nice to direct any replies somewhere else. I did look at vbMAPI and have a few questions in to them but certainly for now what you gave me is just fine. Thanks again.

dick