how to mail merge labels from excel to word on mac book pro

Note: If your label outlines aren't showing, go to Design > Borders, and select 'View Gridlines.' Step Three: Connect your Worksheet to Word's Labelsīefore you can transfer the data from Excel to your labels in Word, you must connect the two. Your label outlines will now appear in Word. Here, you can select your label brand and product number. In the drop-down menu that appears, select 'Labels.' Next, head over to the 'Mailings' tab and select 'Start Mail Merge.' Go ahead and save your list and let's head over to Microsoft Word. Once you're finished, your list should look something like this:

Once you've finished creating the headers, go ahead and input the data.

RELATED: How to Create and Print Labels in Word You can even insert images in the mailing labels if you want, but that step would come later in Word. This is the standard information you'll find on mailing labels. Our list will include the following headers: To properly illustrate the steps, we'll go with a personal mailing list in this example. Also, if your list is for companies and not individual people, you can omit the 'First Name' and 'Last Name' header and just go with 'Company Name' instead. Titles are always nice, but it's important that you know which title a person goes by before creating the labels. Which headers you include depends on which information you plan to use in the mailing labels. Place those headers in the first row of each column. The first thing you need to do is create a column header respective to the data that goes in each column. If you haven't created the list yet, despite Excel's lack of the mailing label function, we still highly recommend you use Excel since it's better for organizing and maintaining data than using a Word table.

If you have already created a mailing list in Excel, then you can safely skip this test. However, when you get ready to print mailing labels, you'll need to use mail merge to create them in Word from your Excel list. You may be using Microsoft Excel to organize a mailing list neatly.

How to mail merge labels from excel to word on mac book pro