Sending mail.

[mlw901]

Hi again

I have a macro that sends a workbook as an attachment to an email address specified in a certain cell. However, i would like to disable the outlook express 'send/do not send' message alert so i can display my own.How can this be done?

Cheers

 

[Tom Morales]

I'm not familiar with Outlook Express, but Outlook (Office 2000 and greater) has a similar alert. I presume that it's to prevent the propagation of viruses of the "I Love You" variety. If there were a way around it, I'm sure hackers would have come up with a new virus that would exploit the loophole.

_________________
This message was edited by Tom Morales on 2002-11-12 14:26

 

[Jack in the UK]

Hi Yes this can be done but i underline Toms comments. so i will never tell the work arroun

I also NOW am technical staff and as such i would throw anyone i found deliberatly tripping Microsofts defences in this manner off the roof, its not on

Not being dificult, its there to protect you, use it would be my advice

JITUK

 

[ShidanTowfiq]

I have a legit corporate use for this topic and found a workaround elsewhere that is not necessarily virus-friendly, AND it still suits my requirements of automatically sending a batch of unique e-mails with attachments to a predetermined list of department managers. I didn't want the Accountant to click 'Yes' 80+ times. The e-mail message is displayed briefly, so if this process is used for a virus, it's going to be blatently obvious to the person whose PC it's running on. Anyway, here's the code:

Instead of using:
aEmail.Send

Use:
aEmail.Display
Application.SendKeys "%s", True

And now a batch of unique e-mails is completely automated without any messages popping up, unless there is a spelling error and spell check is activated in Outlook for all messages.

I hate it when people won't share information...

Shidan

 

[christianbiker]

Ok...so where would i put this code in vb?

 

[Bagsy]

You may be able to turn the warning off in outlook express depending what version you are using.
Try
Tools
Options
Security
and clear "warn me when other applications try to send mail as me"
You have this option in Outlook Express 6