How to Run VBA Code in Your Outlook

At times you may wish to utilize VBA code in Outlook to achieve more functions. Yet, you do not know how to run VBA code in your Outlook. Thus, this article will expose the detailed steps to you.

Thereinafter, we will take Outlook 2010 version as an example and show you the elaborate steps, ranging from modifying macro security settings to running VBA code. Now, read on to get them.

Step 1: Enable “Developer” Tab

  1. First of all, after launching Outlook, access “File” menu.Access File Menu
  2. Then, in “File” menu, select and click on “Options”.Select Options in File Menu
  3. Next, in the popup “Outlook Options” window, switch to “Customize Ribbon”.
  4. Later, on the right side, you can find out and enable the “Developer” tab.Enable the “Developer” Tab
  5. Lastly, click “OK”.

Step 2: Check Macro Security Settings

  1. After returning to Outlook main window, you can access “Developer” ribbon.
  2. Then, click on the “Macro Security” button.Open Macro Security
  3. In the subsequent screen, you should select “Notifications for all macros” and hit “OK” button.Change Macro Security

Step 3: Access Outlook VBA Editor

To run VBA code, you have to access the VBA editor firstly, which can be achieved by the following 2 means:

  1. In Outlook, under the “Developer” tab, click on the “Visual Basic” button.Access VBA Editor by "Visual Basic" Button
  2. Or you can directly press “Alt + F11” key buttons.

Step 4: Add VBA Code

  1. In VBA editor, namely “Microsoft Visual Basic for Applications” window, you need to expand the “Microsoft Outlook Objects” folder on left side
  2. Then, double click on the “ThisOutlookSession” project to open it.Open “ThisOutlookSession” Project
  3. Subsequently, you can copy and paste your VBA code into the white editing pane of this project.Paste VBA Code
  4. Optionally, you can copy the VBA code into a module.
  • Click “Insert” button in the menu bar.
  • Choose “Module” from the drop down list.Insert New Module
  • Then, a new module will display. Now you can copy code into the module as usual.New Module

Note: In general, you can paste the code into either “ThisOutlookSession” or a module. But, the VBA code involving events, like “Application_Start”, must be put in “ThisOutlookSession”.

Step 5: Run VBA Code

After adding the macro, you can run it. In the macro window, you can press “F5” key button or click on the “Run” button in the toolbar.Run VBA Code

Note: For the VBA code involving events, like “Application_Start”, you ought to restart your outlook to activate it.

Optional Step: Add Macro to Quick Access Toolbar or Ribbon

If you would like to run macro in the main Outlook window instead of in the VBA editor, you can add the macro to Quick Access Toolbar or ribbon.

Add Macro to Quick Access Toolbar

  1. First off, access “Outlook Options” by following the operations shown in Step 1, in which you can shift to “Quick Access Toolbar” tab.
  2. Next, select “Macros” from the “Choose commands from”.
  3. Then, in the macro list, choose a macro.
  4. After that, click “Add >>” button in center.
  5. Finally, click “OK”.Add Macro to Quick Access Toolbar
  6. Since then, to run this macro, you can simply click the macro button in Quick Access Toolbar.Run Macro through Quick Access Toolbar

Add Macro to Ribbon

  1. At first, go to “File” menu and click “Options”.
  2. In the subsequent “Outlook Options” window, turn to “Customize Ribbon”.
  3. Then, on the right side, click “New Group” button.Create New Group in Ribbon
  4. Next, click “Rename” button.
  5. In the popup dialog box, specify a name and icon for the new group, such as “Smart Move” in my instance, and click “OK”.Rename New Group
  6. Later, on the left side, select “Macros” from the drop-down list of “Choose Commands from”.
  7. After that, in the macro list, select the macro you want.
  8. Then, click “Add >>” button in center to add this macro to the custom group.Add Macro to New Group
  9. Next, click “Rename” button.
  10. In the new dialog box, change the name of this macro and assign an icon to it.Rename the Macro Button
  11. Ultimately, click a series of “OK” until getting back to Outlook main window.
  12. Now, you will see the new macro button in ribbon, as shown in the following screenshot.New Macro Button in Ribbon

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf recovery and outlook repair software products. For more information visit www.datanumen.com

11 responses to “How to Run VBA Code in Your Outlook”

  1. A digital girlfriend provides you a hassle-free way of conference ladies without the commitment that you could not obtain from really satisfying someone face to face. As stereotypical as it can seem to state that a particular citizenship is a certain way when it concerns dating, there are guaranteed social distinctions. You can come close to a woman and make sure she will grin and also approve your presence. Some of them will approach you out of anxiety, while others will certainly do it merely due to the fact that they don’t see you as a person special. Korean women, there are in lots of people see south korea if that’s what to an off-day? You might begin your search online first if you want to day Brazilian ladies. That is why numerous Brazilian girls wish to move and hence, look for a connection with an American or European guy. The 22-year-old vocalist – whose complete name is Giulia Bourguignon Marinho – meant their brand-new relationship by publishing cryptic images on Instagram on Valentine’s Day.

    Situations might differ yet according to sociologist Luana Pinheiro, the maid-boss (frequently maid-madam) relationship is essentially among entry. Award champions include ladies that are on the front lines of neighborhood, national, and also worldwide obstacles, as well as are functioning to break down obstacles to promote favorable change, however may additionally be females that are functioning behind the scenes, quietly making a crucial distinction in Brazilian culture. To read more regarding the champions and the effort, please go to: The Victors of the 2020 Females Making a Distinction Honor. Undoubtedly, the Brazilian fans applauded heartily for the US and also for bronze-medal winners Japan after the suit. “Today of Thanksgiving is the best moment for us to share our thankfulness and appreciation to these eight impressive Brazilian ladies, who function tirelessly to sustain as well as progress their communities”, stated united state. Several of one of the most relevant names in architectural digital photography in the world are currently females, as well as Brazil is no various. The US females, that deal with crowds a lot worse than this when they play on the roadway, most likely found this tame. Teddy Moutinho has a beautiful face as well as a lovely curved body. American setter Lindsey Berg.

    Spend for the bill – that’s how South American dating etiquette jobs. As the first female Exec Planner, she functions tirelessly to help the communities they represent gotten over obstacles to protecting land titles. He made his launching as a substitute in the FA Mug encounter Tranmere on January 4, with his very first start coming in the replay loss. Nadine Anflor, Porto Alegre (RS): is the initial female to increase to the rank of Chief of the Civil Cops in Rio Grande do Sul, managing a large business structure including thousands of civil law enforcement agent, investigators, and regional precinct principals. But existed really ever any type of question that Rio would certainly be a party? There are numerous angles, I will state that”. Both memberships are generally the same other than the Platinum subscription enables you to speak to every member on the site. For more details on this Press Launch, please call the U.S. Brasilia, November 23, 2020: The united state Yes, their medal-stand parties could have been a little bit disconcerting to the American eye, however it was additionally hard not to share at the very least a little in the joy of their success.

    American outside player Logan Tom after the suit. The Olympics, nevertheless, are not simply another Globe Organization or Brazilian Superliga suit. White hot celebrity ladies would have given anything to have that swarthy sunlight- tanned skin which is particular of Brazilian lovely women. The bottom line is that if you have your eye on a lady, seek her as well as make her feeling desired. The main goal of this best Brazilian dating neighborhood is to make an ideal day. It wouldn’t be an exaggeration to name her among the very best actresses from Brazil. They do not fear the sun rays and also excited to wash in the warm sunlight that is ever before existing in Brazil in any kind of area. Previous Brazil global, Hulk, has revealed he is currently dating the niece of his ex-wife Iran Angelo de Souza after their divorce. If you are established to date a Brazilian single, after that take a look at our testimonials of the most effective Brazilian dating websites

  2. These instructions fail miserably. I followed your other article about creating a VB macro to automatically expand all folders. Problem is, though I created the macro perfectly, the system cannot find it to link it to Outlook. Therefore, I must conclude that these instructions, as well as those regarding the expansion macro, are completely useless. It was worth a try, I suppose, but in the end I fell for yet another set of tips and tricks that fail to deliver as promised. There’s way too much of that on the web!!

  3. Nope. No luck here. So I followed your directions to the letter on how to make the folders in Outlook all expand when I open the program. But when I try to link to that macro, the system cannot find it. Thus, I’m afraid these instructions (both this one and the one for the expansion macro) are utterly useless. I’ll have to scour the web for something that actually works becuase Microsoft was terribly short-sighted (no surprise there) to not give the user such a critical function.

  4. getting error 430: VBA Class does not support automation or does not support expected interface.

    Does it mean my company outlook does not allow or support running VBA macros from outlook?

  5. Howdy just wanted to give you a brief heads up and let you know a few of the images aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different web browsers and both show the same results.

    Proxyti.com/buy/2000-private-proxies/

  6. Superb blog! Do you have any hints for aspiring writers? I’m planning to start my own site soon but I’m a little lost on everything. Would you advise starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m totally confused .. Any tips? Cheers!

    Proxyti.com

  7. Hi, this guide is great but I’m just unclear on one part – how do I select the tasks please?
    Looking forward to hearing from you!
    Mel

Leave a Reply

Your email address will not be published. Required fields are marked *