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

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

  1. Wow, marvelous blog format! How long have you been blogging for?
    you made blogging glance easy. The total look of your site is fantastic, as well as the
    content material! You can see similar: and

  2. We would like to thank you all over again for the
    stunning ideas you offered Janet when preparing her
    own post-graduate research plus, most importantly, regarding providing each of the ideas in a single blog post.
    Provided we had been aware of your web page a year
    ago, we may have been kept from the unnecessary measures we were taking.
    Thanks to you. toys for adults

  3. We would like to thank you yet again for the wonderful ideas you gave
    Janet when preparing her post-graduate research in addition to, most importantly,
    for providing every one of the ideas in one blog post.
    In case we had known of your web-site a year ago, we will have been rescued
    from the useless measures we were choosing. Thanks to you.
    adults toys

  4. Right here at LatamDate, we have actually constructed a knowledgeable team of computer as well as protection professionals to develop a series of practical anti-scammeasures to stop our on-line dating individuals frombeing scammed. Your trustserves as the safety shield that protects you frombeing scammed on Latin dating websites. Release your inner detective as well as Google Colombian women you come across on online dating web sites to see if their name ever pops up on various other web sites cautioning you be careful or they have actually ever been captured before. Google their pictures to see if they have been taken as well as recycled from some other dating profile. And while we usepremium anti-scamprotection devices to ensurethat our foreign male users are dating actual Latina scammers, women and also scammers constantly improviseto developed new means to target unwary individuals and also take their money. Because fraudsters and also fraudsters are banned by LatamDate in situation our team of safety and security experts identifies any type of questionable activity or get problems from individuals, defrauders will certainly try to move communication off of LatamDate app or website prematurely. No makers, giants, or crawlers can pass the security tests as well as examine the enrollment web page.

    After producing an on-line account, you can easily surf hundreds of accounts. When written profiles are not enough, take a look at her homemade Video Program! Fill in a membership form, go via all the profiles for complimentary, and after that decide whether to update to a Costs subscription, which offers you ingress to a wide variety of items and also services when you’re all set. Deal safe, straightforward services as well as a system to members. Sincere participants looking for their excellent suit have fantastic accessibility due to the comprehensive network. Largely based on the prescient and creative of a wonderful Latina woman, you can choose the requirements of search and also you’ll positively find a variety of women’ customers that might activate you to obtain interested. A fantastic way to allow a girl know that you want her, and also they’re FREE to send! You’ll learn in regards to the final finish pertaining to the procedure using electronic mail. An enjoyable means to get more information regarding the women prior to taking the following step. Conversation in real-time making use of text and also smileys, it’s enjoyable and romantic, as well as translation is offered if needed! So you can take a remainder and it’s not needed to stress over any kind of fraudsters on this website.

    Do NOT let scammers and scammers make the most of you by providing them your depend on so quickly. This method can take some appropriate time to ensure that you won’t take care of to start the search at once. Check out introductory letters from girls totally free, and also if you feel a trigger, start the love and reply! Men that require to begin the connections having most likely the most engaging Latin singles will certainly situate a magnificent couple at latamdate. It is vital to attempt to maintain in mind that in addition to the set by on the website info, each girl would certainly require to love as well as be valued. Hence, if your’re the single guy who is serious for looking for a latin lady for marital relationship or longt term relationship, you don’t need to bother with the language as well as society obstacles. Our EMF Mail assists you to conquer language and cultural barriers and connect smoothly.

    You as well as your lady to listen to each various other’s voices without language or cultural obstacles. You can express your love and also like your woman by sending her lovely computer animated present products with personalized welcoming words. You can either create a thorough account as soon as possible or avoid all the steps during the enrollment and invest just 1 min to join. Discover out whether this latin dating site meet your needs or otherwise and after that comprise your mind whether to join on the website or not. As an example, all the regional marriage companies are called for to authorize a created Solution Agreement with LatamDate as well as to conform with all the conditions of the Contract, accept abide by LatamDate’s defined practices & procedures which may be upgraded once in a while to enable high quality of services provided on the site. The service principally low-cost, nevertheless in a number of level, it warranties reliability with regard to anti-scam techniques.

  5. Great blog you have here.. It’s hard to find high-quality writing like yours these days. I truly appreciate individuals like you! Take care!!

  6. 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

  7. 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!!

  8. 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.

  9. 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?

  10. 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.

  11. 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!

  12. 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!

Leave a Reply

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