Monday, October 5, 2009

Enable VB macros to run in Outlook

Want my macros to run on customers' computers with high security level. Find explanation of security levels here.
http://office.microsoft.com/en-us/ork2003/CH011480831033.aspx

Code signing certificates cost a few hundred dollars a year. Here is a list of providers from Microsoft.
http://msdn.microsoft.com/en-us/library/ms995347.aspx

To self sign, use selfcert.exe. Run
C:\Program Files\Microsoft Office\OFFICExx\selfcert.exe
http://www.howto-outlook.com/howto/selfcert.htm

In the VB Editor go to Tools, Digital Signature and add the certificate to the project.

Get out of the VB Editor and Outlook and go back in. Outlook will ask if you want to always trust macros from this certificate. Say
yes.

Outlook macro project is here.
File: VbaProject.OTM
Folder: %appdata%\Microsoft\Outlook
Example: C:\Documents and Settings\username\Application Data\Microsoft\Outlook

VbaProject.OTM location

The VbaProject.OTM is in the Application Data\Microsoft\Outlook folder for the user.

The %APPDATA% variable identifies this location.

See
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=341

Windows and DotNetNuke Web Hosting

Get Windows and DotNetNuke webhosting from http://www.webhosting.vg/.

Programmer.bz

For programming articles, tips, software development assistance, outsource programming, go to http://www.programmer.bz/.