[Trentham]

Today it started hanging again. It'd been going quite nicely all day but then decided to start being silly!

> Are you still using the option to send silently? What sort of code?

I'm not sure I understand you. In outlook I never had to set anything to send quietly, it just did it. The stuff I'm sending is a simple message (in plain text) with a simple text file attached. The code I'm using is (as near as makes no difference) the same as discussed earlier anmd lifted from the MS site.

[Rollin_Again]

Did you get all your problems solved regarding automating your Outlook? I have done quite a bit of coding for this in the past so just let me know if you still need help.

By the way, there is a way to bypass the security prompt you that Outlook generates. Lemme know if you need instructions.

Rollin

[MustBNuts]

rollin....yes please. I have a vb code but, as shown on the attached jpg earlier in this post, I'm getting that pesky prompt....

any and all helps appreciated.

MBN

[Trentham]

It all seems to be working OK now. I guess I'll never know why it occasionally hung on a second attempt.

I'd be interested to know about the security prompt and how to get rid of it. ATM I don't get any such prompt and didn't know one existed but if it should start happening.....

[Rollin_Again]

The security prompt is something that was added by Microsoft to prevent the spread of viruses. It was included in one of the service packs and can only be removed by completely uninstalling the service pack. Fortunately, you have a couple of other options to overcome the problem without having to remove the service pack.

The first options is to first display your email on the screen and then use "SEND-KEYS" to trick the program into thinking that the "S" key has been pressed. This send key method will only work if the letter "S" is underlined on the send command button of the security prompt dialog. The underlined letter on the command button indicates which letter is associated with the keyboard shortcut. If you do not use the "S" as a keyboard shortcut for the send button, you will have to use send-keys to send a series of TABS until the right button is selected and then send an ENTER send-key.

NOTE: EMAIL WILL NOT BE SENT IN DEBUG MODE You must fully execute your macro in order for the mail to be sent. I tested it several times and it works!


Public Sub Mailer()

Dim objol As New outlook.Application
Dim objmail As MailItem
Set objol = New outlook.Application
Set objmail = objol.createitem(olmailitem)
With objmail
.To = "Anybody@hotmail.com"
.cc = "SomebodyElse@hotmail.com"
.Subject = "TEST EMAIL"
.Body = "THIS IS THE BODY"
.NoAging = True
.Attachments.Add ("C:\TEST.txt")
.display
End With
Set objmail = Nothing
Set objol = Nothing
SendKeys "%{s}", True

End Sub

************************************************************************
METHOD #2

The second option is to use a small freeware program called Express ClickYES. This freeware will click the YES button automatically for you when you are prompted by Outlook. I have tried this program and it work quite well. The only downside to this is that you have to have the program running in your system tray at all times for it to work. Some companies like the one I work for do not allow us to run "unauthorized" programs on our work machines and will not allow the software to reside on our computers.

Click Here for Express ClickYES freeware


Keep us posted on your results.


Rollin

[MustBNuts]

Thanks rollin! I knew about the sendkeys, and requiring the display of the email defeated the purpose. I have a small app that sends an email to a customer on a regular basis and the whole idea is to make it as transparent as possible.

Thankfully, my co. is not that strict about unauthorized programs, especially progs installed by IT for IT. I will now try to get this app on its own schedule and see if I can, for the most part, allow it to fend for itself!


Thanks again,

MBN

[Trentham]

Perhaps I'm not seeing this then because I'm using Office 2000?

[Rollin_Again]

Originally posted by Trentham:
Perhaps I'm not seeing this then because I'm using Office 2000?

It really depends on what Service Packs you have installed on your machine. I can't quite remember which one came with this Security feature. I also use Office 2000 but the problem appears for me.

Rollin

[Trentham]

Apparently it comes in with Outlook 2000 with SP!+SR1 or SP2.

I must say that if this is MS's idea of a 'fix' I continue to be unimpressed. The reason to use this facility is because I actually want these emails to go out... all 200 of them and I don't want to be asked about each one!

I'll see if ClickYES makes it transparent, other than that, I'll keep on with my 'older' but uncrippled version!