Outlook security warnings when sending e-mails from Access...

[Nano]

Solved! Outlook security warnings when sending e-mails from Access...

I know that this is a problem that many people face, but I couldn't l find a way to solve it. I am running a database that keeps track of my companies chemical catalog. I just programed a new feature that allows a person to request a reorder of anything in the catalog. It works almost perfectly, it checks the database every 3 hours if there is something on the list and will try to send an e-mail if there is something that needs reordering. The problem is I get a security message that blocks the email from sending until it is approved or denied. I have looked up ways like changing the trust center options and editing the registry, but none of this ways have worked. Is there a way to disable this warning without having to pay for a bypass software? I am using Office 2010 and this database is running on windows XP.

Thank you.

 

[Nano]

So it wasn't easy but I did find the work around using the registry. It seems to be a common problem so here is how I did it.

For Outlook 2010 **Note Back-up registry, just in case.**
1) Open the Registry Editor (Type regedit.exe in the Run.. box)
2) Navigate to
"HKEY_CURRENT_USERS\Software\Policies\Microsoft\Office\14.0\Outlook\Security"
3) Create a new DWORD named "PromptSimpleMAPISend" (Case Sensitive)
4)Double-click it and enter a value of 2 (Hex or Decimal will work)
5 Restart Outlook and the warnings should be gone.

I found this instructions after a day of searching, however sadly I don't remember the web page to give credit.

 

[AccessMSSQL]

You might want to also take a look at Outlook Redemption. I use this to avoid the security prompt when using Outlook. Plus, if you are releasing to a production environment with many users you can't always mess with the registry key.

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