Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! Go back to the top menu bar, and return to the Start Mail Merge menu.
Choose the Select Recipients option. This is where you will select the spreadsheet with all your contact information in it, so find the folder where your file is located. Your Word document should now be populated with a small box representing your mailing label. You can also design any additional elements you want on your label, including custom content like your company logo, that you want on each label. This will insert a merge field on your sample label for each address on your list.
From the Insert Address Block window, you will be prompted to choose your preferred formatting for the address information. If a window called Match Fields shows up, that means that you need to sync up the merge fields in Word with the corresponding column titles in your Excel contact sheet.
On this window, click the drop down arrow next to any unmatched category, and choose the corresponding column from your Excel contact sheet with the corresponding information in it to match them up.
Select the option to Update Labels , and all of the mail labels in your document should update. To review your results before you print, choose the option from the top bar called Preview Results , and click through to preview your labels. You may also look at the following articles to learn more —.
Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.
By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Popular Course in this category. Course Price View Course. Next, you need to choose the size and type of the labels you're printing. Open a blank Word document. Go to the Mailings tab. Choose the brand in the Label Vendors box and then choose the product number, which is listed on the label package.
You can also select New Label if you want to enter custom label dimensions. Click OK when you are ready to proceed. Before performing the merge to print address labels from Excel, you must connect the Word document to the worksheet containing your list. The first time you connect to an Excel worksheet from Word, you must enable a setting that allows you to convert files between the two programs.
In Word, click File. Scroll down, and select Options at the bottom of the left pane. Click Advanced in the left pane of the Word Options window and then scroll down to the General section. Make sure the Confirm file format conversion on open is selected and click OK. Navigate to the Excel worksheet containing your list in the Select Data Source window that opens and click Open. Click OK to confirm that you want to use the list and click OK again to select the table containing your list. The page will now be filled with labels that say « Next Record».
After you've organized the data, you need to add mail merge fields before you can complete the merge. This is where those headings you added to your Excel worksheet will come in handy. Make sure your headings correspond with the required fields.
0コメント