Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have excel 2010 report which has a script that runs automatically emails report via outlook 2010 but it will only work if I have Outlook open via right click and Run as Administrator.

Is there a way to fix this?

share|improve this question
not really. usually the correct response to UAC is to install a windows service that runs at boot as an elevated user, and have userland apps call it to perform admin actions, but in your case, you are running up against two boundraries; the one Outlook uses to prevent viruses from sending emails, and the fact that the admin action is coming from a userland app, and can't be easily shifted into a service. – Frank Thomas Feb 28 '13 at 13:57
You could always fix the script so this isn't required. You can also set the shortcut for Outlook to always run as an Administrator through the shorcut compatability options. Without more information we can't really help. – Ramhound Feb 28 '13 at 13:58
well I just figured out part of it. This excel file pulls data from Oracle so even this excel file I have to run as administrator, if not it won't connect to oracle and after data is pulled I have it to email me automatically but for it to send email me automatically outlook must be open as run as administrator, however another excel file i have which as raw data doesn't require oracle connection it sends me email via outlook without having to run outlook as administrator. This doesn't make sense to me. – Mowgli Feb 28 '13 at 14:04

You must log in to answer this question.

Browse other questions tagged .