DONOR LIST 2011.xls
Save this file on your computer in folder where you know where it is.
DONOR
LIST 2011.pdf
2011 JAM 15160 AVERY LABEL.doc
This file has already been merged to Donor List 2011.xls and can be
used to print directly to Avery 15160 Labels. (Labels are 1 x 2 5/8)
INSTRUCTIONS
FOR DOWLOADING AVERY SOFTWARE AND CREATING YOUR OWN LABEL TEMPLATE
If you are not using Avery 15160 Addressing Labels you will need to
create a template for labels you are using and merge to Donor List
2011.xls
Selecting
and Downloading Avery Label Software
- Go to www.avery.com - Click on Templates/Software (at Top of
Page) then Software
- Select - Avery Wizard for Microsoft Office
- Click on Free Download - Downloading window will appear -
You may have a Warning at the top of page that windows is blockiing
download - click on x at top to permit download
- Window - Do you want to Run or Save
- Save - identify where on your computer you want to save the
Wizard file ( Desktop or folder of your choice)
- Not necessary to Register
After Wizard 4.0 is
installed on your computer
Click on Avery Wizard and follow instructions
- Next
- Select Producet (Making Labels) you are using (purchased)
- Next
- Select Template - Blank label in top left hand corner
- Next
- Merge data from an exhisting data file (Your data file is the
Donor List 2011.xls that you have saved to a folder from the
jamshow WEB site.)
- Next
- From Excel
- Look in the folder you saved the file and click on it
- Next
- click on Sheet 1 (Make sure that a check is put in box to
identify data file contains headers in the first row)
- Next
- Field names - Right hand box
- Select Company
- (add field to layout)
- Enter Key (Return)
- Select Donor
- Enter Key
- Select - City,
State, Zip
- Next
- Finish Review labels and make any corrections necessary.
- Save file using file name that you will remember to a folder on
your computer
- Print - print to a sheet of paper to be sure printer is working
before loading label paper in printer.