Avoid repeating yourself: Create a Word macro

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

Repeatedly entering the same information in document after document, over and over…there has to be a quicker way, right? Word macros can save you time (and potentially, some sanity) by automating repetitive tasks.

Let’s say you’re a real estate agent. Every time you sell a house you have to add a client’s name and address to multiple documents. Creating a macro automates adding all of a client’s contact information wherever you need to.

Setting up the macro

Creating a macro is straightforward and doesn’t require any coding knowledge. You simply tell Word when to start and stop recording a series of steps; for example, from when you start typing a client’s name to when you finish. Then Word will perform all of those steps automatically when you click a button or enter a keyboard shortcut that you assigned to that macro.

Here’s a step-by-step:

1.  Go to the View tab, click the Macros dropdown and select Record Macro


In the Record Macro dialog box, you’re going to to name and describe your macro, and then choose whether you want to run it via a button or keyboard shortcut.

2. In the Macro name field dialog box, give your Macro a name that has no spaces in it, e.g.,AdamSmith instead of Adam Smith.

3. The Description field is for you. Over time you might create dozens of macros and might have trouble remembering which is which. Enter a description that will help you out.

4. In Store macro in field, define whether the macro will run in your current document or in all documents. Choose the option–All Documents–to run it in all documents.

5. Decide whether you’ll use a shortcut or button to run the macro by clicking the Button or Keyboard icons. For this exercise, click Button

Adding the macro button to the Quick Access Toolbar

After you click Button, Word lets you add your button to a place where you can easily find it–the Quick Access Toolbar

1. In the Word Options/Quick Access Toolbar box, click the name of your macro, and then click Add to include it on the list of other commands on the Quick Access Toolbar


To make sure you can identify the button on the toolbar, you need to choose a type of button.

2. Click Modify, and then choose a button from the dozens available.

Recording your macro

As soon as you choose your button and then click OK,  the macro starts running, recording your keyboard strokes until you stop the recording. For example, I chose the button of a guy wearing a tie, clicked OK, and the macro started recording the address I typed of a fictitious client named Adam Smith who lived in Lincoln, Nebraska. When I finished typing, I clicked Stop Recording in the Macro dropdown. 

Here’s how you can do that yourself:

1. In the Modify Button dialog box, choose a button and then click OK .  

2.  Click OK again in the Word Options box , and the macro starts running.

3.  Perform the actions you want to include in your macro. 

4.  Once you’ve completed the actions, go to the View tab, select the Macro tab and click Stop Recording

5.  You’ll now see that a button for your macro now appears on the Quick Access Toolbar. Just click it, and the same actions that you recorded will happen again wherever you put your cursor in a document. You’ll see this button on the Quick Access Toolbar in all of your Word documents–unless you chose that it only appear in your current one.



Join the conversation

  1. Whilst your technical explanation is good, the example given of what a macro might be used for is not. A simple AutoText entry saved to the Quick Parts gallery would be better.

    • nice information. Thank you for sharing it. Thanks Packers Movers

  2. Almost nobody in this modern world does not have a social network account. Either in Facebook, twitter or LinkeIn, everyone has an account used to connect with friends, family and all other people who shares the same interests as they do. All these social networking sites have one thing in common, they are created to serve as a platform for all people to interact and share information about them.
    This is actually a very affordable way to connect with people as well as organizations. Aside from that, small businesses and entrepreneurs who are searching for ways to enhance their market range will find social networking sites to be profitable. For regular individuals who are only expecting to add more friends since they do not have much time to socialize outside of work and their homes, the creation of these networks is really very beneficial.
    What better way to look for friends who shares the same interests as you do but on these social networking sites social networking. Awkward conversations can be skipped now that and your new friend obviously have a particular topic you can talk about. No more guessing and no need for gazillion questions to be asked.
    With businesses, social media’s cost effective ways are giving them pure benefits. By opening an account on any of those social networking sites, you are also creating a customer relationship management (CRM) tool for free which is very important for every company. If you want to sell your products and services, it is essential that you have your own CRM.
    Hiring an advertising company to promote your business would cost you an arm and a leg and if you are a starting company, it may be needed but it can also be risky on your part. It is not a sure move that this advertisement will work, but with social networks, it will go straight to people who have the highest possibility of being your next customer.
    International companies use these websites for the same reason. They are not afraid of advertising costs however, being able to reach out to customers outside of their country and having to spend zero to little amount spells as savings and that will never hurt the company social network. If they can promote it that way, why should they spend millions?
    Whatever your reasons in creating a social media account, it will surely provide you with the result you are aspiring for. For people who are just looking for fun and hoping to meet people, these sites allows you to interact with other people who loves the same things as you do. Old friends, lost relatives and even classmates you hadn’t seen for ages can be possibly found in any of the social networking websites. Just learn to reach out and don’t be shy.

  3. my company has 4 sites in the U.S. with each their own terms and conditions which are flowed to their suppliers. i want to create a template in which any given sites terms and conditions are pulled in based on a drop down selection that allows the user to pick a specific site. can this be done? perhaps a marco is not the proper method to use. any help is appreciated.

Comments are closed.