I am trying to create an automated system (using a VBA macro) that will download production data from our company database after the end of a shift and automatically Email this data to a select list of people (namely, Senior Operations Management).

When I do this manually in EXCEL using the "Send To ..." command everything goes fine. When this is done under macro control I get a dialog box (titled "Microsoft Outlook") that says: "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?". I need to click "Yes" manually (after a five second delay) to proceed. Needless to say, I don't want to have to be at work to click the button at 11 pm (or 7 am!). I've tried various security level settings on both Excel and Outlook with no success.

I realize that there are "virus concerns" here, but is there anyway to send Email automatically from a "trusted source"?

I would appreciate your comments and suggestions ...

Thanks!

Peter

Peter,

Suggest you view the code snippets relating to Automation on the page at http://www.vba-programmer.com

CarlR