I've read some about sending an email from and Excel program using VBA and getting around the security prompt - "a program is trying to send ...".

I'm trying to automate an SFTP download using an Excel program. The process works fine when the user starts the Excel program manually. What I would like to do is have the Excel program started automatically as a Windows scheduled task and, when it is finished downloading and processing the data, have it send an email to several users. Using CDO requires a 'From' email address which doesn't exist because it's an application (Excel) that sending.

Is there another way that an email message can be sent?

Thanks.