{"id":20159,"date":"2022-12-21T17:32:33","date_gmt":"2022-12-21T04:32:33","guid":{"rendered":"https:\/\/geektactics.geektamin.com\/?p=20159"},"modified":"2024-06-13T15:42:39","modified_gmt":"2024-06-13T03:42:39","slug":"how-to-get-a-prompt-before-sending-emails-in-outlook","status":"publish","type":"post","link":"https:\/\/geektactics.co.nz\/blog\/how-to-get-a-prompt-before-sending-emails-in-outlook\/","title":{"rendered":"How to Get a Prompt Before Sending Emails in Outlook"},"content":{"rendered":"
If you’re anything like me you will have multiple accounts set up in Microsoft Outlook. I can’t tell you how many times I have emailed a client from my personal email without thinking. There’s a simple fix for this problem that involves three<\/strong> simple steps.<\/p>\n <\/p>\n Most people never need the Developer tab, so it is usually disabled.<\/p>\n Start Now:<\/strong><\/p>\n <\/p>\n <\/p>\n The next step involves some code, but you can simply copy and paste it from below.<\/p>\n Start Now:<\/strong><\/p>\n <\/p>\n <\/p>\n <\/p>\n Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)<\/strong><\/p>\n Dim prompt As String<\/p>\n If Item.SendUsingAccount = “email@domain.com<\/span>” Then<\/p>\n prompt = “Are you sure you want to send from<\/span> ” & Item.SendUsingAccount & “?”<\/p>\n If MsgBox(prompt, vbYesNo + vbQuestion, “Sample”) = vbNo Then<\/p>\n Cancel = True<\/p>\n End If<\/p>\n End If<\/p>\n End Sub<\/p>\n <\/p>\n <\/p>\n Outlook protects your emails, etc by disabling all macros from running on your computer, unless they have a certificate. In this case, you will create your own certificate, which only works on your computer.<\/p>\n Start Now:<\/strong><\/p>\n C:\\Program Files (x86)\\Microsoft Office\\root\\Office16<\/b>.<\/p>\n If you don’t find it in this folder, try this folder:<\/p>\n C:\\Program Files\\Microsoft Office\\root\\Office16<\/b><\/p>\n Remember this certificate name.<\/p>\n <\/p>\n <\/p>\n That’s all there is to it. Enjoy<\/p>\n <\/p>\n .<\/p>\n","protected":false},"excerpt":{"rendered":" If you’re anything like me you will have multiple accounts set up in Microsoft Outlook. I can’t tell you how many times I have emailed a client from my personal email without thinking. There’s a simple fix for this problem that involves three simple steps. 1. In Outlook, turn Developer mode on Most people […]<\/p>\n","protected":false},"author":3,"featured_media":20217,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-20159","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functionality"],"yoast_head":"\n1. In Outlook, turn Developer mode on<\/h2>\n
\n
<\/p>\n
\n
<\/p>\n
2. In Outlook, use Visual Basic Code to Create the Prompt<\/h2>\n
\n
<\/p>\n
\n
<\/p>\n
\n
\n<\/strong><\/li>\n<\/ul>\n\n
At this stage, test your macro. Create and attempt to send an email from the email account from this step.<\/h4>\n
3. Create a Self-Signing Certificate<\/h2>\n
\n
<\/p>\n
\n
\n
In Visual Basic, Apply the Certificate<\/h3>\n
\n