Print Recipient Number with airSlate SignNow

Avery address label template form

hi and thank you for watching my youtube video today we are going to discuss how to print mailing labels or address labels and we're going to be using the Avery 5160 or the 80 160 so what I did is I created a spreadsheet here with columns ABCDE which have the column header the name address city state and zip and I put some fake names in here let's start by saving this and I save it to the desktop as a file called address alright I'll hit save and I'm gonna go ahead and close this now I'm gonna go and open a word document a new document and in this case we're using Microsoft Office 2016 so the first thing we're gonna do is really go to mailings here you can see this tab alright then we want to go to start mail merge and we can select labels and this is a label feature where you can actually look up product numbers and your vendor so in this case we're using the Avery US letter and the compatible one is a 5160 address label and we're gonna hit ok so now it's set up for that next thing we're gonna do is we want to take the data from the excel spreadsheet we've created and we want to import that so we go to select recipients we want to use existing list all right we're gonna locate that list and we saved it on the desktop and we'll select address hit open and now it's gonna ask us to select a table and there's only one table in there and check off that the first row of data contains column headers because remember we had column a1 was the name and then the column two was address so let's hit OK and now you see the first record here in the following records the next step is to insert the merge fields which is going to be the information such as the name the address the city state and zip and you have to think of it as the names on the first line the second lines your address and the third line is your city state and zip so we want to insert name and hit enter again insert merge field and address enter insert merge field city let's give a space and then state and give a space and then zip now we entered this data into the first one but we want to update all labels so let's hit update the labels and what you see is the fields that you put into the first one here are now in the rest of them now we want to preview the results so if we preview the results we can see that now all those address labels are in the template here that's ready to print and since we only have one page so now let's go to finish and merge and we want to edit individual documents and merge records all and from here we can then go ahead and put our label paper or the mailing labels into the printer and simply choose our printer and print and this will print out your labels which then you could remove and be done any questions let me know again this is creating mounting labels Avery five one six zero or the eighty one sixty compatible ones using Microsoft Office 2016