Creating Mailing Labels in Mail Merge: Part 2

"Hi, I'm Gary for Expert Village. And once we go ahead and put the address block into the label, then we can go ahead and try to edit it. Again, since we did not match up any of our fields, nothing is going to appear there. Even if we go ahead and update all of the labels, there is nothing to update it with so in essence, we are going to be left with a blank page. Over here we have the option to replicate labels and that means the layout that we choose in our first label of the address block that will apply to every single label that we have on the sheet. So we don't have to go ahead and edit and choose the address block format. We can just go ahead and replicate it for every single label. As we go ahead a complete the merge, you can see we have no fields here because we did not line up the fields. So basically we are left with a blank document because Word does not know where to put our data base field. So what we would have to do is we would have to go back to where we choose to insert the fields and we would have to click on the match field button. Over there we can go ahead and start putting in matching last name, first name with the text that Microsoft Word uses to the names that I chose for my data base. So we see address one, I call contact address one. Go ahead and hit okay and then I go ahead and save it. We see the format what it is going to look like and now if I go up top, since this is the second time I am adding it in. The first time I didn't have any fields. I'll erase one of those merged fields and be left with only one address block as it would have printed twice. And then when I want to preview my labels, now I will be able to preview them. Each one of these fields will have been updated with my first address block the way that I formatted my first format box. Now we see that each field is printed with the same format name, address, city and state and this is the way we complete our labels. We go ahead the same way scrolling through to see if we need to edit anything. To see if there is an address with names misspelled or if there is an address that is not correct so that we can identify before we go ahead and print it and obviously it is much better to do it now and we can go ahead and complete the merge. And completing the merge will ask us if we want to print right away or edit the individual labels. I always choose to edit it because then we can be sure and take a look at it before it is actually printed. So I am going to merge all my records and here would be the final labels. I only have seven records so it is all on one sheet so this would be what my sheet of labels would look like."