Now we need to copy all the merge fields into all the boxes. Then click the Open buttonĬlick in the first box and click the Insert Merge Field buttonįrom the pull-down select each of the following fields and place on a new line so it looks like this. Navigate to where you have saved your addresses.xlsx file and select it. Now we need Word to link to your Excel database of addresses.Ĭlick Select Recpients and then select Use and existing list DO NOT ADJUST THIS (it should be the precise measurements for your Avery number) Now scroll down the list and find the Avery number for your labels - usually on the box ( L7162 is a common one for 8 rows and 2 columns)Ĭlick OK and you should see a table created for you with dotted lines. If it isn't already selected make sure your Label vendors is set to Avery A4/A5 sizes from the pull down list first. Use Word to create a document to design the labelsĬlick on Mailings along the top and then the Start Mail Merge button - looks like this. Use Excel to create a Database of AddressesĪ ready made sheet called addresses.xlsx can be downloaded by clicking the link below Click here to download addresses.xlsxĢ. If you’re satisfied with how they look let’s move to step 6 and complete the merge.This article describes how to use Excel and Word to print out address labels on a standard Avery 8 rows by 2 columns (16) of sticky labels per sheet of A4.Īll you need is Excel and Word and some Sticky labels.ġ. Now, on the mail merge menu you can click through the Recipients by clicking the back or forward arrows. If you doing hundreds of labels … I would just spot check them. Your document screen will look similar to this. This will populate each label with the fields from the fist label. Now over on the Mail Merge menu bar you will want to select the “update all labels” button. For instance on this label I would want the First Name before the Last Name. You can edit them by highlighting the field and moving it to where you want. Now if you look over at your document you will notice these fields are being added to your labels. Just double click on each field you want to include. Now we can choose the order of the data we want presented on the labels we are creating. Ok, we’re almost complete, just a couple more steps. Click on Next: Arrange your labels. Since I know the data source is what I want I chose Select All. Here you can change the order of your information, delete certain users, and validate information. You will click on a confirmation screen verifying your data source (I used an Excel spread sheet that I had imported from Access) and get to Mail Merge Recipients window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |