Skip to main content

Posts

Showing posts with the label MS Outlook

Making Macro Security Warnings Disappear

You know those annoying Microsoft Office Macro Security Warnings? There is a way to make them disappear, at least for you. Here's the Steps. Find the Microsoft Office Tools folder generally under Start > All Programs > Microsoft Office > Microsoft Office Tools Select Digital Certificate for VBA Projects (if you don't have such a link see this article ) Fill out the form and name it "Whatever makes you happy" Open your Microsoft Office Application and Open Visual Basic Editor Navigate to the Macro that is causing you Warnings Go to Tools > Digital Signature and click Choose Highlight the Certificate you just created, e.g. "Whatever makes you happy" Restart the Microsoft Office Application This time when you get the security warning choose, "Always Trust this Publisher" No more messages!

Attachment Reminder - and more for MS Outlook

I just did it again. We don't like to admit it, but we all have. You write a long letter describing the attachment, press send and then 10 seconds later remember you didn't actually attach the message. I finally decided to do something about it. Turns out it isn't too hard. Chiefly because Jimmy Peña at Code for Excel and Outlook already did all the hard work of writing up an excellent MS Outlook Etiquette Check Macro that does all the dirty work for you. What's left for you to do? In MS Outlook go to Tools > Macros > Visual Basic Editor Under the Project Panel (far left) Browse to Project1 > Microsoft Office Outlook Objects > ThisOutlookSession Double-click ThisOutlookSesson to Open (if you haven't been here before this will be a big blank canvas) Visit Code for Excel and Outlook Etiquette Check Code and select "Copy to Clipboard" at the top of the code. Or you can also copy from the code I've modified below if you prefer....