I have Office and can't find out how to do it. I have a huge project coming up in April and need to use my Excel address document to make labels. Unless you have the Starter Edition of Word , which doesn't support mail merge, you can either start the mail merge manually or use the free Avery Wizard. The latter will give you a choice between Edit Individual Documents Was this reply helpful?
Yes No. Sorry this didn't help. Thanks for your feedback. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Then at the bottom click on Next:Arrange your labels. This is where you will choose which of your columns are merged and in what order. Click on each field and then click on Insert one at a time. For example, here we will need to click on First Name and then click Insert, then click on Last Name and then Insert, and so on.
Once every field is added, click on Close. In the first label, you can click between each field to add spaces, line breaks, or any other characters. For example, we've added spaces between each field, moved the addresses to another line, and a comma between the City and State. Then click on Update All Labels to apply these changes to the entire sheet. You can then click on Next: Preview Your Labels to move to the next step. On this step you can preview the first sheet.
If there are any other spaces, line breaks, or characters you need to add you can click on Previous: Arrange Your Labels to go back to the previous step and make adjustments. If everything looks correct then you can click on Next: Complete The Merge.
0コメント