autosend excel file via outlook?

[fmkjr]

I have some files that are "autorun" and sent each day via the windows scheduler. The files are opened, code is run then sent. All systems are being changed over to an exchange server and an issue with outlooks security features show up. (There are aprox 80 files like this that are run and it would be a real pain to do this manually...) that and the fact they can be run even when not at the machine.

Apparently, there is a security feature built into outlook to prevent spam... Before sending the email a msgbox opens asking the user to click and verify to send the email.

I saw something concerning a redemption dll to be installed... has anyone used this code and if so has it worked for you?

thanks
frank

 

[Zack Barresse]

Hi there, yes this is a pain. Check out Outlook Redemption, CDO, OutlookSpy and ClickYes.

 

[fmkjr]

thanks!

I appreciate the help!

frank