Product Tips

Office Technology Tips – What are Macros and Why are they Useful? 

What is a Macro, Anyway?

Simply put, a macro is a series of steps & instructions that you group together to create a single command which can accomplish tasks with the press of a single button.   Here is an actual example of how you can use a macro.  Let’s say your CEO holds you responsible for a monthly report that includes merging 5 Excel spreadsheets together, plus 3 Word documents; then reformatting them, editing, and resizing; and then the ugly task of printing these reports to ledger-sized paper so they can be distributed at the monthly board meeting.

Just the sound of those steps would make most people cringe. Wouldn’t it be nice if you could wave a magic wand and have them done for you,  automatically? This is why macros are amazing. All you need to do is set up your task by doing it once, and the macro tool will record every step and build a program which, when finished, will launch again when needed by the press of one single button.

How to Create a Simple Macro

In this exercise we’ll do something as simple as printing mailing labels. This is a repetitive task that involves opening a Word document, choosing labels and a template, and then setting up which printer it will go to, changing the media type to labels, sizing and then printing it.  When counting the steps involved, it takes 18 mouse clicks to accomplish. But with the macro we will create, the steps will be cut down to one click – and it is literally this easy.

In any program when your documents are ready, just follow the steps below:

  1. Click View > Macros > Record Macro.Recording a Macro command
  2. Type a name for the macro.Macro name box
  3. To use this macro in any new documents you make, be sure the Store macro in box says All Documents (Normal.dotm).Box for choosing where to store a macro
  4. To run your macro when you click a button, click Button.Click to assign the macro to a button
  5. Click the new macro (it’s named something like Normal.NewMacros.<your macro name>), and click Add.The macro and the Add button
  6. Click Modify.Modify button in the Customize the Quick Access Toolbar box
  7. Choose a button image, type the name you want, and click OK twice.Button options in the Modify Button box
  8. Now it’s time to record the steps. Click the commands or press the keys for each step in the task. Word records your clicks and keystrokes.

    NOTE:  Use the keyboard to select text while you’re recording your macro. Macros don’t record selections made with a mouse.

  9. To stop recording, click View > Macros > Stop Recording.Stop Recording command

The button for your macro appears on the Quick Access Toolbar.

Macro button on the Quick Access Toolbar

To run the macro, just click the button!  You can do this with almost any task within Microsoft Office.

Do you have any good macro tips? Please share them with us!

Cold Weather Must-Haves for the Office

 

snowflake_banner-hello-winterIt’s the first official day of winter, and we’re seeing some cold weather! We’ve put together a list of winter essentials to help keep your workplace safe and warm. Type the below item numbers or keywords into our search box and you’ll be one step closer to comfort. Something we missed? Let us know by adding a “paper clip” in the comments below, we’d love to hear from you!

 

SAFETY:

Keep your employees safe and warm with our cold weather gear. Ward off slips and slides with our ice melt and entry mats. And be prepared with charged batteries a plenty:

  • Ice Melt (EONBLUEICEMELT)
  • Entry Mats (GJO59466)
  • Northflex Cold Gloves (NSPNF11HD8M)
  • Waterproof Safety Boots (SVS18801BLM100)
  • Hand Warming Packs (EGO16990)
  • Weego Jump Starter Battery + (Search: Weego)

ice-melt-image

BREAKROOM:

There’s nothing like sipping a warm cup of coffee or tea, or slurping chicken noodle soup while watching the snow accumulate outside your breakroom window. Stay energized, healthy, and keep your belly full with our cold weather breakroom essentials:

  • NEW! Flavia Coffee Line (Search: Flavia)
  • *SEASONAL Spicy Eggnog Keurig K-Cups (GMT6774)
  • *SEASONAL Wicked Winter Blend K-Cups (GMT6205)
  • *SEASONAL Creamers (Search: Peppermint Mocha or Pumpkin Spice Creamer)
  • Tazo Zen Tea (SBK149900)
  • N’Joy Gourmet Oatmeal (Search: NJoy Oatmeal)
  • Healthy Choice Chicken Noodle Soup (CNG17173)
  • KIND Healthy Snack Bars (Search: KIND Bars)
  • Planters Heart Healthy Mixed Nuts (KRF05957)

njoy-oatmeal-cup_product-image

HEALTH, WELLNESS & COMFORT:

A cold or the flu can spread through your workplace like wildfire. Keep your office sanitized and sniffle free with our preventative care items. And should sickness take hold, we have you covered with the medicine and warmth you’ll need to keep the shakes at bay while you work away:

  • Airborne DualAction Immune Support (AVTSN18531)
  • Genuine Joe Disinfectant Wipes (GJO14142)
  • NEW! Purell Surface Spray (Search: Purell Surface Spray)
  • Purell Hand Sanitizer Office Starter Kit (GOJ9652K1)
  • PhysiciansCare Cold & Cough Medicine (ACM90092)
  • Indoor Portable Space Heater (LLR33557)

 

goj9652k1

 

 

We’re confident these items will add just the right amount of calm and cozy to your workplace!

 

*Seasonal Items are available for a limited time only.

 

Wet Erase Markers vs. Dry Erase Markers

If you are anything like the average person, you may not really understand the difference between wet erase markers and dry erase markers. It depends on the type of project you have that will determine which marker is the best for you.

It’s important to remember that using the wrong type of marker on a whiteboard will leave streaks and residue behind. In order to avoid those unsightly marks, avoid leaving any writing up for an extended amount of time. This makes cleaning more difficult.

Here’s a little comparison chart to help:

Wet Eraser Markers: Dry Eraser Markers
  • Wet erase markers contain water-soluble dyes and are intended for acetate, film or non-porous laminated surfaces. Works great with projection screens.
  • Wet erase markers use a paste-based ink rather than alcohol based, which makes their markings semi-permanent.
  • Erase by using a damp cloth
  • Dry erase markers erase with an eraser on most non-porous materials, like whiteboards, porcelain, melamine and glass.
  • Do not use on a projection screen.
  •  Contains water-soluble dyes that will penetrate and stain porous surfaces.
Older Posts