asked on

Authorize automated email from VBA

Is it possible to authorize VBA code, such as the following:

thisworkbook.sendmail "me@here.com", "Here is your worksheet"

I've got Office 2003 on the computer. I would like to keep my computer relatively secure from VBA vulnerabilities so I'm not looking to simply shut off all security in Outlook, but perhaps allow the mail-sending scripts from a particular worksheet to be sent.

Thanks,

BoB

Patrick Matthews

Hi BoB,

Have a look at:

http://www.contextmagic.com/express-clickyes/

or:

http://www.dimastr.com/redemption/

Regards,

Patrick

BoB

ASKER

Patrick,

Thanks for the comment. Clickyes looks more in line with my capabilities, and I'm wondering if you can comment on the fact that it doesn't work when the computer is locked. The task that I'm trying to perform is to have the computer send it's IP address in an email to me once a day; I can't get a fixed IP address for my office computer and I would like to have access to it via a Remote Desktop Connection. The only programming tool I have available is VBA, however perhaps there is a more elegant way to solve this problem.

In any case, a RDC locks the computer which means, as I understand from the website, that clickyes may not be the best option. Would you agree?

Thanks,

BoB

ASKER CERTIFIED SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BoB

ASKER

Patrick,

Thanks again for your comments; I have one last question. With up-to-date antivirus protection and a client-side firewall, is there a serious risk in bypassing the security patch in Outlook? I imagine that any scripts floating around out there would not know to use the Redemption object model so that also adds a level of security through obscurity. Can you comment on security?

BoB

Patrick Matthews

BoB,

I am not a network security expert, so I am afraid any answer I may give you there may lead you astray.

Patrick

BoB

ASKER

OK Patrick,

Thanks for the help.

BoB

Patrick Matthews

You're welcome, and thanks for the grade.

Patrick