2016 Outlook Certificate Problems

Status
Not open for further replies.

Calendar

New Member
Outlook version
Outlook 2016 32 bit
Email Account
POP3
1. On a brand-new home installation of Office 365 (currently 2016), I opened Outlook and created three new calendars, then copied the very nice Slipstick VBA macro to open Outlook at the calendar with two calendars selected, adapting the cases in the macro in the obvious way. It worked well, briefly, then it wanted a certificate.

2. I created a certificate using SELFCERT. Then using MMC, I found the new certificate in 'Current User/Personal' and copied it (right-click Copy, then right-click Paste) into 'Current User/Trusted Root Certification Authorities'. I was unable to copy it into '(Local Computer)/Trusted Root Certification Authorities'.

3. In Outlook's VBA editor, I signed Project1 with this certificate. Then I exited Outlook, saving the project.

4. Every time I opened Outlook, however, I got the error message, 'An error occurred while attempting to verify the VBA project's signature. Macros will be disabled.' Then whenever I went into the VBA editor, I found that the project was unsigned again.

5. So I deleted the macro, intending to go back to 'Outlook-out-of-the-box' (but understandably I cannot delete Project1). There are now no macros to display, yet every time I start Outlook, I get the same error message, despite the fact that I keep trying to sign Project1 with my certificate. I've also set 'MacroSettings' temporarily to the lowest level, which one would expect should bypass certificates. Thus I am completely stuck, because I cannot even go back to where I was before I started doing all this.

QUESTION: Presumably I am doing something wrong with the Certificate, but I have googled obessively and read numerous blogs on the subject, and tried all sorts of suggestions proposed there, and I can't sort it out. Does anyone have any clues about all this? I know that Windows is obscure, but I have never struck anything like this --- it's held me up for hours.

Windows 10 Pro 1709 on 64-bit desktop, with ESET Smart Security 9, and VPN by Private Internet Access
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It worked well, briefly, then it wanted a certificate.
Was the security level changed?

Then using MMC, I found the new certificate in 'Current User/Personal' and copied it (right-click Copy, then right-click Paste) into 'Current User/Trusted Root Certification Authorities'.
Don't move /copy it, you can trust it in the Trust Center or in the allow macros dialog.

(but understandably I cannot delete Project1)
You can delete it from the hard drive. Outlook will create a fresh clean copy the next time you open the VBA editor. It's at %appdata%\microsoft\outlook
 

Calendar

New Member
Outlook version
Outlook 2016 32 bit
Email Account
POP3
Was the security level changed?


Don't move /copy it, you can trust it in the Trust Center or in the allow macros dialog.


You can delete it from the hard drive. Outlook will create a fresh clean copy the next time you open the VBA editor. It's at %appdata%\microsoft\outlook
 

Calendar

New Member
Outlook version
Outlook 2016 32 bit
Email Account
POP3
Fixed! And it all survived reboot! (And apologies for mucking up the reply a few minutes ago.)

1. I deleted the project file as you advised, and everything returned to what it was before I started fiddling with VBA macros. What a relief!

2. After closing and relaunching Outlook a couple of times, I set the Trust Centre's Macro Settings to 'Notifications for all macros' --- I'm not sure whether this was the best choice, but it has worked. When I restarted Outlook, I had to give permission to various certificates, but it was very straightforward to check that each was genuine.

By the way, I had tried various settings of the security level before, but none of them had worked.

3. I then repasted the adapted 'SelectCalendars()' macro text into a new module of Project1, ran it a couple of times to check it, then digitally signed it. I had copied, not moved, the Certificate previously, so I did not even launch MMC --- nevertheless everything worked as it should. (The extra copy of the Certificate should surely not be a problem.)

Thank you, Slipstick, for the very useful macro, and than you very much, Diane, for helping me sort out the Certificate business. It was all too subtle for me.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
U Outlook 2016 Outlook 2016 sender name Using Outlook 1
S Outlook (2016 32bit; Gmail IMAP) - Save sent message to Outllook Folder Outlook VBA and Custom Forms 0
A Backup Email Accounts On OutLook For Mac 2016 (Microsoft 365 subscription version) Using Outlook 0
M Office 2016 Outlook is forgetting passwords Using Outlook 15
E Can one still buy Outlook (or Office) 2016? Using Outlook 6
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
R seperate read layout to design in outlook 2016..Help!! Outlook VBA and Custom Forms 3
GregS Why is Outlook 2016 mail in Outlook.com? Using Outlook 1
G Recurring tasks break links Outlook 2016 Using Outlook 5
A How to get body of all emails in outlook 2016 to view in blue color Using Outlook 1
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
GregS Outlook 2016 iPhone won't download Outlook 2016 Mail. Using Outlook 0
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
A How to open a specific link automatically with outlook 2016 Outlook VBA and Custom Forms 6
V Outlook 2016 will not move emails in search results Using Outlook 4
K Using Outlook 2016 to draw Using Outlook 1
M Outlook 2016 Free/Busy settings ignored Using Outlook 0
K Outlook 2016 - controlling IMAP OST size with Group Policy not working Using Outlook 1
C Outlook 2016/2019 hangs after being open for an extended period Using Outlook 4
GregS 2016 Contact List being managed by Outlook.com? Using Outlook 1
A Outlook 2016 in Cached Mode Using Outlook 1
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
N Outlook 2016 Folder Icons Look Using Outlook 0
Marc2019 Outlook 2016 Font Problem Using Outlook 5
B Outlook 2016 Does not Shutdown Correctly Using Outlook 3
GregS Outlook 2016 Outlook 2016 stalls Using Outlook 3
H Outlook 2016 sent over 30 copies of an e-mail with attachments Using Outlook 1
Q Problems with Autodiscover Outlook 2016 Using Outlook 0
D Importing Outlook Categories from another domain (Exchange 2016/Outlook 2016) Using Outlook 4
Q Unable to Sync Quicken reminder with Outlook 2016 64Bit Using Outlook 1
J How to open OST file in Outlook 2019 & 2016 Using Outlook 1
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
K Outlook 2016 Using Outlook 0
L What are the risks of opening an Outlook 2016 .pst file in Outlook 2010? Using Outlook 4
David Langer Outlook 2016 (365) How to restore the ability to Re-Map iCloud IMAP Folders Using Outlook 5
W Search Incomplete Outlook 2016 Using Outlook 5
A Outlook 2016 not synching Using Outlook 4
B The Outlook 2016 Profile that isn't always there Using Outlook 2
D Outlook 2016 customization of incoming messages Using Outlook 1
J Command Button to stamp a date and time in a textbox in Outlook 2016 Outlook VBA and Custom Forms 3
J Checkboxes when selected will appear in a textbox in Outlook 2016 Outlook VBA and Custom Forms 1
N Outlook 2016 Address Book lookup Using Outlook 9
D Outlook 2016 automatically increment anniversaries Using Outlook 1
D Sharing outlook.com calendars in Outlook 2016 Using Outlook 1
S Adding new Exchange (2016) rule very slow down Microsoft Outlook Exchange Server Administration 0
M Outlook 2016 Requesting data from server Using Outlook 0
P Outlook 2016 Client and 365 - Groups Folder Using Outlook 3
P Add a contact to the New Task in Outlook 2016 Using Outlook 2
T Outlook 2016 is not receiving emails until I restart it Using Outlook 1

Similar threads

Top