Back

Save Time with Avery Wizard to Create Labels and More

Avery Wizard

Avery Wizard provides those using Microsoft Office step-by-step directions for creating labels, business cards, name badges and more. It works within the Word program and you can simply import lists from excel or other database programs. You can also manually type in your data if need be. Avery allows for pre-designed templates or blank [create-your-own] options. Below is how to use it.

First Step: Download Avery Wizard

Download Avery Wizard for Outlook here. It is also available for other operating systems like Mac. Once downloaded, it should be in view in Word as a new tab. See below.

Download Avery Wizard - A - NENS Boston IT CompanyDownload Avery Wizard - B - NENS Boston IT Company

Second Step: The mail merge

Follow the wizard in choosing your Avery product by name or number, then the design (pre-defined or custom) and the options for entering info. Next, the screen below will appear to import using an existing data file or creating a new one.

Select and hit Next. Select the data file that contains your address list. Click Next.
If you don’t have a spreadsheet with all of your names and addresses, you can start with our pre-formatted files for Microsoft Excel or other database programs.

After uploading the data, you can choose which rows of data you want to use by adding the specific fields to your layout [see below]. You can also add punctuation and spaces, and edit your graphics in this phase. Click Next.

 

Your project is now complete. Choose which direction you want to print your labels or cards and Click Finish. Your project will pop up and be ready to print. Be sure to check that no fields were bumped off the page due to length or size of data.

At any point you can click the Back button to return to the previous screen.

 

Client Feedback

“We are about 60% more effective, since we contracted with NENS. The new IT structure helped our office work more efficiently and NENS was able to help make our performance faster. NENS was able to diagnose issues quickly and fix them in a timely manner.”

—Kristen Hammond
Read More