AveryWizardForWord95-English.exe
AveryWizardForWord97-English.exe
AveryWizardForWord2000-English.exe
AveryWizardForWord2002-English.exe
AW20_PLUS_EUR.exe – Avery Wizard Plus

NOTE: The Avery Wizard uses macros that will not harm your system. If you receive a Security Warning about Avery Dennison Cooperation macros when installing or running the Avery Wizard: Select "Always trust macros from the source" and click "Enable Macros".

1- The speed of your modem.
2- The speed of your telephone connection.
3- The time of day you trying to download the Wizard. There are busy periods.
4- Web traffic. Many people are trying to download the Wizard resulting it being too slow and therefore "timing out’ or ‘Automatic disconnection’.
5- Surfing the web while downloading the Wizard i.e. having many web browsers open as downloading the Wizard making it even slower increasing the chance of errors occurring.

1- Click the ‘Start button’ on the taskbar, select ‘Settings’ then ‘Printers’. Then in the ‘Printers’ dialogue box right click on the icon for your printer and select ‘Properties’. From the ‘Printer Properties’ window you need to locate the ‘Paper Size’ tab. This option normally defaults to ‘Letter size’. If so, change this to ‘A4’ then click on ‘Apply’ then ‘OK’.
2- Some printers have a ‘Reduce /Enlarge’ facility that defaults to 94% or 97% (instead of 100%). Click on ‘Start’, ‘Settings’ and ‘Printers’. Right click on the icon for your printer select ‘Properties’. In the ‘Layout’ tab select ‘Custom’ in the ‘Scale to’ increase to 100%.
3- If you are using Microsoft Word, click on ‘Tools’ - ‘Envelopes and Labels’ and then ‘Options’. Make sure that the ‘Label Products’ is set to ‘Avery A4 and A5 sizes’ (not Avery Standard) and then highlight the Avery template you require.
4- If you are using Microsoft Word 97/2000/XP click on ‘File’ and ‘Print’ then select ‘Options’ and deselect the ‘Allow A4/Letter resizing’, click ‘OK’. Click on OK to print.

Outlook
1- Click on ‘File’ then ‘Import/Export’
2- Choose ‘Export from a file’
3- Select ‘Comma Separated Values (Windows). This will create a .csv file.
4-Select the folder the address is held e.g. ‘Contacts’
Give the file a ‘Name’, and then use the ‘Browser’ window to locate a folder on your hard drive your hard drive to save the .csv file into e.g. ‘My Documents’ folder.

Avery Wizard
1-In the Wizard select ‘Use an existing list or database file’.
2-Click on ‘Open File Not Listed here’.
3-Browse your hard drive for the .csv file (saved above), making sure that in ‘Files of Type’ is changed to ‘Microsoft Text Driver’ (*txt, *csv).
4-Highlight the file
5- Click on ‘Open’ and follow the rest of the Wizard as normal.

Alternatively you can use the 'Tools' and 'Mail merge' option that already exists within Word.

The Avery Wizard has built-in margins to avoid text printing over the label edges. The text input window should be a good representation of the usable space. However, due to anomalies with graphic cards and video driver metrics, there is a chance that the text input window is not 100% the same size as the printable area. At present there is no fix for this, regrettably it is completely beyond our control.

The filter function only works in databases created within the Wizard i.e. the ‘CREATE A REUSABLE THEN PRINT FROM IT’ (in the .doc format). Databases from other sources e.g. dbase 3, comma separated file (.csv), excel (.xls) etc. can not be sorted not filtered in the Wizard.
As a alternative use the filter function within the Mail Merge in Microsoft Word

Run through the Wizard as normal, after clicking on ‘Finish’ you are presented with your labels in Word. Click on ‘Insert’ then ‘Text Box’ on the menu bar. Draw a text box within the label, click on Insert Picture, select your picture using the browser dialogue box and click on Insert. Click on the border of the text box, when the cursor changes into a double-headed arrow ‘Right click’ and select ‘Format text box’ from the menu. With the ‘Colours and lines’ tab selected, select ‘Colour’ from the ‘Line’ section then select the drop down menu. Select ‘No Line’. This will ensure that the border of the text box will not be printed. Then simply copy and paste the image across to the rest of your labels.

If you have the Avery Wizard on CD, the new CD's have a 'UPDATED MARCH 2003)' on them. If you need a copy of the FREE CD software (UK customers only) please submit a request via the “Contact Us” link on the top right of this page or by contacting the Consumer Centre FREE on 0800 80 50 20.

When uninstalling the Wizard from ‘Add/ Remove Programs’ you will sometimes (depending in your version of Microsoft Office or maybe Windows) get the message (to the effect) ‘do you want to remove shared files, removing shared files can be harmful to your computer if you are not sure click on ignore’ then you have the options to either ‘Yes’, ‘Yes to all’ or ‘Ignore’. Usually if you are not sure you would select ‘Ignore’ however since this is Avery software you would select the option ‘Yes to all’. This option fully removes the Wizard from the PC.

-Open up Microsoft Word and click on the wizard icon to launch the Avery Wizard
- Click next, then select the label code then click NEXT
- Now select use an existing list or database file and click NEXT
- Click once on your database, which should be visible in the "YOUR FILES" window.
- Then click on the view and update file button below
- This brings up the screen allowing you to add or remove records, hit NEXT
- This will bring up a sample label click select the "NO I WANT TO ADD OR REMOVE ITEMS" option and click NEXT
- The next screen contains a SORT and FILTER button on the left-hand side. You can use this to Sort/Filter the records.

To locate these Mac templates insert the CD into your Mac and browse the CD for the ‘MACFORMAT’ folder.
* If you need a copy of the FREE CD software (UK customers only) please submit a request via the “Contact Us” link on the top right of this page or by contacting the Consumer Centre FREE on 0800 80 50 20.

1. From the 'Tools' menu, select 'Envelopes' and 'Labels'. For Microsoft Word XP click on 'Tools' - 'Letters and Mailings' - 'Envelopes and Mailings' and then 'Options'.
2. If 'Labels' is not already selected, click on the 'Labels' tab and choose 'Options'.
3. Make sure that in the 'Label Options' box the 'Label products' is set to 'Avery A4 and A5 sizes'.
4. Highlight the Avery product you are using and click OK.
5. For single labels, or for a full sheet of label, type in the text and click 'New Document'.
6. To create a blank sheet and type your information directly onto each label, click on New Document and type in the text.

1. From the 'File' Menu, choose 'Tools', then 'Envelopes and Labels.' For Microsoft Word XP click on 'Tools' - 'Letters and Mailings' - 'Envelopes and Mailings' and then 'Options'.
2. Select the Labels tab, and then select 'Options'.
3. In the 'Label Options' box ensure that the 'Label products' is set to 'Avery A4 and A5 sizes' and not 'Avery Standard'.
4. Select the Avery product code purchased, and then click on OK.
5. With the address window empty, and 'Full Page of the same label' selected, click on 'New Document'.
6. From the 'New Document' screen, type the different label entries in the cells and print as usual.

When installing to a network not all ‘users’ are allowed to install software, this depends how the network is set up. This error message is common to these types of problems.

The Template and the Custom boxes should both hold the same path to the DesignPro folder. The correct path of the Template folder should be C:\DesignPro\Templates. This path is represented by the drive you have
installed the DesignPro folder to (which by default is usually the ‘C’ drive, or it will be drive you have installed it to) then the DesignPro folder and finally Templates folder (which is located within the DesignPro folder). If the path for the Template Folder is different from above then you need to re-link the file to
the correct folder by clicking on the ‘Browse’ button on the right side of
the ‘Templates’. To do this click on the ‘Browse’ button locate the ‘DesignPro’
folder then click on the plus sign to the left of it this should bring up the ‘Templates’ Folder. Click on the ‘Template’ Folder then click on the ‘OK’
button.
The other option is uninstall the software and reinstall as s ‘Typical’ installation.

1- Click on ‘TOOLS’ then ‘OPTIONS’ select the ‘PRINT’ tab and put a tick in ‘SUPRESS BLANK LINES’ and click on ‘OK’.
2- Also click ‘FILE’ - ‘PRINT’ then ‘OPTIONS’. In the ‘DATABASE’ section place a tick in ‘SUPRESS BLANK LINES’ and click on ‘OK’.

Sometimes if you go into PRINT PREVIEW it still shows the blank lines. This is a BUG, however when you print it out it will not print out the blank lines.

Note if the Tagged box is greyed out then click on ‘Database’ and ‘Modify’.
Place a tick in ‘Tag’ field and click on OK. At the next Warning box click
on ‘Yes’. Then carry out the steps as above.

- Open Excel and click on FILE / OPEN, in the FILES OF TYPE select ALL FILES, locate your LabelPro.avd file (usually in the LPWIN 20 folder) highlight the file and click on OPEN
- Delete the first column called ‘PRCNT’ which contains TRUE and FALSE statements. To do so right click on the ‘A’ column and select the DELETE command. Click on FILE and SAVE AS in the SAVE AS TYPE select DBASE (dBase III) file type in a name for your database then click on SAVE.
- Open DesignPro and then open your converted database by clicking on DATABASE / OPEN.

Another column heading could have field name ‘Address_2’. Go back to the original file in Excel/ Access etc and then remove the under score. So the column heading should now read ‘Address2’.

Alternatively convert the database to a DBASE III in your database software. Then ‘open’ the file through DesignPro by clicking on DATABASE and OPEN. Choose the first option ‘Open a Dbase III file’ then locate your converted dbase III file then click on ‘OPEN’.

To specify what type of barcode you want, click again inside the barcode box and highlight the barcode numbers and then right click on it. Select BARCODE PARAMETERS then select the type of barcode from the drop down arrow in the TYPE box. Click on OK to confirm.

If you have already created a database and you want to add the ‘Barcode’ field then use the DATABASE and MODIFY command. Please note the MODIFY option is only available in DesignPro version 3.5. To find out which version you have, click on HELP and ABOUT. The version number will be on the first line.

If you do not have version 3.5 you can download it from this website by clicking on DOWNLOADS / SOFTWARE and DESIGNPRO 2000.

Alternatively click on ‘Tools’ and ‘Guides’. In the ‘Horizontal’ tab click ‘New’ type 0 (number zero) click on ‘OK’ then click on ‘Horizontal’ again type ’1’ click on OK. Select the ‘Vertical’ tab then in the ‘Vertical’ tab follow the same procedure as above Once you click on the OK four guidelines will appear on the template on the screen. These guidelines can then be dragged to the edges of the template. You will now be able to see the edges of the templates after inserting images/graphics.

1- Place the CD into your PC. Exit any installation box that may appear.
2- Open the afterBurner software, in the ‘How would like to create your
project’ dialogue box select ‘Create a project from scratch’.
3- Select a template and click on OK
4- Then click on the ‘File’ menu and ‘Ready-Made Designs’.
5- Highlight an image of your choice from the various graphic folders and click on OK,
Or
1- Place the CD into your PC. Exit any installation box that may appear
2- Open the afterBurner software, in the ‘How would like to create your
project’ dialogue box software select ‘Ready made designs’
Select an image and double click on it to insert it or highlight once and click on OK.

1- Start from a fresh template leave the master label blank and design on
Label 1. Then click on ‘Insert’ and ‘Label’ this will produce another Label (Label 2) , design your label and click on Insert, Label. Basically you
can do this as many times as you want to.

2- The recommended way is to create a database. This can be done by clicking on ‘Database’ and ‘New’. You are then presented with a three-step guide. First step give the file a name. Second step is to input your fields i.e. the information you want on the label e.g. title, first name, surname,
address1, address2, town, postcode etc. Give the Field length about 35
characters and set the Field database to ‘Text’. The third step would your data within the fields e.g. Mr Joe Bloggs, 1 Regents Street, London, SW1 etc6. Once you have completed this click on OK. The next stage would be to click on ‘Database’ and ‘Insert’ field. This will
show how the label that will be actually be printed off. Click on close,
print preview then File and Print.

Highlight the text. ‘Right’ click on the text and select ‘Character’ from the menu. Then select ‘Colour’ from the drop down menu in the ‘Effects’ box (bottom left corner). Click on ‘OK’ to confirm your colour change.

Alternatively you can highlight the text. Select ‘Format’ (on the menu bar) then select ‘Character’ Then select ‘Colour’ from the drop down menu in the ‘Effects’ box (bottom left corner). Click on ‘OK’ to confirm your colour change.

To make sure this does not happen again click on TOOLS and OPTIONS. In the BARCODE CODE TYPE section click on EDIT. In the PARAMETERS box tick the DISPLAY PLAINTEXT option and then click on OK.

1. Is to connect the printer using an LPT (parallel) port.
   
2. The other is to upgrade your Avery LabelPro software to Avery DesignPro. For more information please visit the Software section of this website.