I have just upgraded from Office 2007 to 2019, and starting to regret it to be honest. In my Outlook on 2007 I had a Templates entry and my frequent templates below that. ALso had a menu for various macros that I used frequently. I have been unable to find how to do that in 2019? I found this link https://its.uiowa.edu/support/article/2655 but all that does is put the Choose Form icon in Outlook, I still have to go and get it from the folder? In 2007 this was all done via a hyperlink?? Whilst I can add a new mail under a new group, no option to link to a template as there is in 2007. So, i ..read more

Hi guys, I have written this outlook macro which works fine on your personal mailbox but it gives an error when I'm trying to run it on the shared mailbox: Code:     On Error Resume Next         Set myOlApp = Outlook.Application     Set mynamespace = myOlApp.GetNamespace("mapi")       Dim strRowData As String     Dim strDelimiter As String     Dim myDestFolder As Outlook.Folder     Dim olRecip As Outlook.Recipient     Dim ShareInbox As Outlook.MAPIFolder     Dim SubFolder As Object   ..read more

I had some VBA that was stored in Outlook for a long time where I could click the macro to run the VBA and it would ask me which folder I wanted to backup, then I would choose. After that it would allow me to browse my file folders to select where to export the data in an Outlook Item format. It disappeared somehow. I thought this may have been it below, but I can't get it to work. I know enough to be dangerous but would like to have something functional again. I get an error when it makes it to this item, saying Sub or Function not defined. SaveItem olItem Code: Sub SaveFolderMessages() 'G ..read more

Hello, I am writing a macro to automate some office work. We have multiple csvs that we get on mail. I am trying to create a macro that Opens outlook -> searches in the subject line -> opens email -> opens attachment. Would someone help me with some resources for this that would explain the logic behind it too ..read more

Hi guys, I've written a macro in outlook that will extract the data from email body and copy it across excel spreadsheet. It's giving me below error: run-time error '-214748111 (80010001)': automation error Call was rejected by callee. Please see below the code: Code: Public Sub Extract()    On Error Resume Next Set myOlApp = Outlook.Application Set mynamespace = myOlApp.GetNamespace("mapi") Dim strRowData As String Dim strDelimiter As String Dim myDestFolder As Folder Dim olMailbox As Folder Dim ShareInbox As Folder Dim SubFolder As Folder Dim InputFolder As String Dim OutputFold ..read more

Hi everyone, I have some code that allows me to amend Good day, to whatever it should be, depending on the time of day. I now have the need to add a BCC as I use 3 different computers, and whilst the IMAP syncs all incoming mail, it does not for outgoing mail. This is the code I am trying to use, however the SenderEmailAddress is empty, so it fails all the time. How can I implement this extra option please. Code: Private Sub Application_ItemSend(ByVal item As Object, Cancel As Boolean)     Dim strGreeting As String     Dim iTime As Integer     Dim strBody As ..read more

What's the proper syntax of changing the font size within HTMLBody in Outlook <style="font-size:11"> doesn't seem to work ..read more

Hello, I want to generate several reports from several existing List views which I've created in Outlook. How to do this? Please guide me. Thanks in advance ..read more

Hi, I've a working VBA code (see att). What is does: Selecting one or more received mail items in Outlook and the macro put a TAG in front of the subject field on every selected mail item. Then every selected item is forwarded to a specific mail adres. The code works fine on one outlook client. Same macro on other pc outlook gives an error "Compile error: Syntaxerror". On both outlook clients the object library reference "Microsoft Outlook 16.0 Object Library" is selected. Attached Files outlookCode.zip (392 Bytes ..read more

Hi team, I have some experience in VBA but I'm rusty and trying to recreate a macros from years ago to display all email recipients prior to sending. So, essentially, a pop-up box would appear when the send button is clicked that will list all the recipients for one last review and a confirmation to send. Any thoughts ..read more