Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Jul 15 09:25:14 CDT 2004
Virginia: I was just struggling with this and I didn't find a VBA answer but the list gave me two good leads for solving the problem outside of Access: http://www.dimastr.com/redemption/ and http://www.contextmagic.com/express-clickyes/ Also recommended by Dan Waters was: Microsoft does offer a free Outlook Security Administration Package. It will allow the administrators in a company to allow programmed email to bypass the 'security message' on an application by application basis. It's free, but it is setup work for the administrators. HTH Rocky Smolin Beach Access Software http://www.e-z-mrp.com ----- Original Message ----- From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com> To: <accessD at databaseadvisors.com> Sent: Thursday, July 15, 2004 5:58 AM Subject: [AccessD] Set Outlook Properties in Access > I am trying to send automated emails through Outlook from Access. I found > this link from Microsoft that tells how to do this. > > http://msdn.microsoft.com/office/understanding/access/codesamples/default.as > px?pull=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp > <http://msdn.microsoft.com/office/understanding/access/codesamples/default.a > spx?pull=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp> > > > > I run into the problem with the security settings - where it pops up the > message about a potential virus and if you want to do this and for how long. > I figure this just 'may' scare off users - imagine that. Anyway, is there a > way to set the Outlook security settings (Tools, Macros, Security) through > Access code, to Low, send the email and then reset their security to High or > Medium again? > > > > I figure there should be a way to do this for Outlook similar to setting the > startup properties, etc in Access when it opens. > > > > Virginia > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >