Creating a new Data File and Merging it into Avery Wizard

Merging Data from an existing Excel file into Avery Wizard

Using the Avery Wizard in Microsoft Excel

Merging Data from an existing Word file into Avery Wizard

1 of 15

Avery Wizard: Creating Databases and Merging data

Creating a new data file and merging it

Open up Microsoft Word and Click the Avery Tab at the top of the screen

Now you can click on the Avery Icon that has now appeared on the top left hand side of the screen.

The Wizard will now open click on the Next Button

2 of 15

Avery Wizard: Creating Databases and Merging data

The Next screen allows you to select the label that you wish to use. Type the product code into the search box and then click Search. Then click Next.

You will now have the choice of 4 options.

Select the “Create a new data file, then merge from it”. Then click Next.

The Save As box will appear and you will need to give the database a name and then click Save.

You will now need to enter the Addresses into the corresponding fields and when you have filled in the first one click on Add new to type the next address in. Once you have finished all the addresses click Close. 3 of 15

Avery Wizard: Creating Databases and Merging data

The label screen will now appear and to the right you will see the Field Names.

Add the fields to the label as required by clicking add field to Layout. Once you have entered the fields click Next.

You will now have the option to either Merge the labels across the page or down the page. Please select the option you prefer. You can now print preview your labels or to click on finish to take the labels into a Word document ready to be printed. Please click on Finish. Once the Word Document comes up. The Labels will be ready to print.

4 of 15

Avery Wizard: Creating Databases and Merging data

Merging data from an existing Excel file

Open Up a blank Microsoft Word document and click on the Avery Tab at the top of the screen.

Click on the Avery Icon that has now appeared on the top left hand side.

The Wizard will now open click on the Next Button

5 of 15

Avery Wizard: Creating Databases and Merging data

The Next screen allows you to select the label that you wish to use. Type the product code into the search box and then click Search. Then click Next.

You will now have the choice of 4 options.

Please select the Merge data from an existing data file option. Then click Next.

6 of 15

Avery Wizard: Creating Databases and Merging data

You now have the Option to select either an Access, Excel or Word Database by clicking on the corresponding tab on the left hand side. Alternatively you can browse for your database by clicking the Browse Tab In this instance we will select the Excel Option. Please click on the Excel Tab

It will now prompt you to select where your database is saved, select the database you wish to use and then click open.

If this box appears you need to select the Sheet where your data is stored (normally this is Sheet1) then click OK.

7 of 15

Avery Wizard: Creating Databases and Merging data

The label screen will now appear and to the right you will see the Field Names section.

Add the fields to the label as required by clicking add field to Layout. Once you have entered the fields click Next.

You will now have the option to either Merge the labels across the page or down the page. Please select the option you prefer. You can now print preview your labels or to click on finish to take the labels into a Word document ready to be printed. Please click on Finish.

Once the Word Document comes up the Labels will be ready to print.

8 of 15

Avery Wizard: Creating Databases and Merging data

Using the Wizard in Microsoft Excel Open up Microsoft Excel and then open your Excel Database. Highlight all of the fields.

Click on Add-Ins then click the Avery Icon that has now appeared.

The Wizard will now open click on the Next Button

9 of 15

Avery Wizard: Creating Databases and Merging data

The Next screen allows you to select the label that you wish to use. Type the product code into the search box and click Search. Then click Next.

On the right hand side you will get your field headings.

Enter the fields onto the label by clicking on “Add Field to Layout “ Please click Next

10 of 15

Avery Wizard: Creating Databases and Merging data

You will now have the option to either Merge the labels across the page or down the page. Please select the option you prefer. You can now print preview your labels or to click on finish to take the labels into a Word document ready to be printed. Please click on Finish. Once the Word Document comes up the Labels will be ready to print.

11 of 15

Avery Wizard: Creating Databases and Merging data

Merging data from an existing Word file

Open Up a blank Microsoft Word document and click on the Avery Tab at the top of the screen

Now you can click on the Avery Icon that has now appeared on the top left hand side of the screen.

The Wizard will now open, please click on the Next Button

12 of 15

Avery Wizard: Creating Databases and Merging data

The Next screen allows you to select the label that you wish to use. Type the product code into the search box and then click Search. Then click Next.

You will now have the choice of 4 options.

Select the Merge data from an existing data file Then click Next.

13 of 15

Avery Wizard: Creating Databases and Merging data

You now have the Option to select either an Access, Excel or Word Database by clicking on the corresponding tab. Alternatively you can browse for your database by clicking the Browse Tab In this instance we will select the Word Option. Click the Word Tab

It will now prompt you to select where your database is saved, select the database you wish to use and then click open.

Now please click Next

14 of 15

Avery Wizard: Creating Databases and Merging data

The label screen will now appear and to the right you will see the Field Names section.

Add the fields to the label as required by clicking add field to Layout. Once you have entered the fields click Next.

You will now have the option to either Merge the labels across the page or down the page. Please select the option you prefer. You can now print preview your labels or to click on finish to take the labels into a Word document ready to be printed. Please click on Finish. Once the Word Document comes up the Labels will be ready to print.

15 of 15

Avery Wizard: Creating Databases and Merging data