Outlook Vba code doesn't work when I restart my machine.

[Jagdev]

Hi Experts,

I have a VBA code saved in ThisOutlookSession. Whenever I restart or start the outlook app it doesn't work. Am I doing something wrong with it. I want it to run when the app gets start.

Regards,
JD

[gmayor]

It probably relates to security issues.

In the Office folder you will find selfcert.exe which will enable you to create a certificate for your own macros.

Having done that, set the macro security in Outlook to provide warnings for all macros, then start the VBA editor and from Tools > Digital Signatures, add your newly created signature to the project.

Close Outlook saving the project at the warning.

Re-open Outlook and you will get a security prompt for the vbaproject. From that dialog choose the option to trust items from the publisher (your certificate).

Thereafter the macros should work normally without prompts.

[Jagdev]

Hi Gmayor
I followed the above steps and created Digital certificate, but after I restart the macrosoft outlook 2010 it throws the attached message and the macro doesn’t work.
Please let me know what I am doing wrong here.
Regards,
JD

[Jagdev]

Hi Gmayor

I am using "Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)" in ThisOutlookSession do I have to add any reference to it.

Regards,
JD

[Jagdev]

Hi Gmayor

I tried the entire process again today and it worked. Thanks for your help on this.

Regards,
JD