- HOW TO PRINT ADDRESS LABELS FROM EXCEL NAME LIST HOW TO
- HOW TO PRINT ADDRESS LABELS FROM EXCEL NAME LIST UPDATE
Select the appropriate Envelope size and click OK.On the Mailings tab, select the Start Mail Merge / Envelopes Command.
HOW TO PRINT ADDRESS LABELS FROM EXCEL NAME LIST HOW TO
The remaining steps will show how to create the mail merge in Word to create envelopes. The steps above created a workbook containing a table of addresses on one sheet that has a name (Addresses) defined that corresponds to the table range. Save your workbook (Addresses.xlsx) and you are now ready for the mail merge.Using the arrow handle in the lower right corner of the table, resize it to just include your addresses. The Table will need to be resized to exclude the blank rows.Select the records that are unconfirmed and cut and paste them to the new worksheet below the headers.Select the table headers and copy and paste to a new worksheet (I named the sheet “NeedAddresses”).The next step is to cut and paste the unconfirmed addresses to another sheet in the workbook Click on the Sort A to Z command and click OK.Click on the dropdown in the 2008 column.Next I want to separate the table into 2 tables one for confirmed addresses and one for those that need to be updated. Once you have the new column, then you can type something in the column to indicate whether the address is correct. The Table and the name that we defined will expand automatically. I do this by adding a new column to the Table for this year. In the New Name dialog, type the name Addresses and the range of cells your addresses are in ($B$2:$G$15 in this case)Īfter my Table is created and a name applied, I start going through the addresses to confirm which ones are correct.To define a name, click “Define Name” command on the Formula Tab.This is helpful in this case because I want to add and remove addresses during the process of printing envelopes.
HOW TO PRINT ADDRESS LABELS FROM EXCEL NAME LIST UPDATE
When a name is defined for a Table in a worksheet, the name will update automatically as the table is resized to add or remove data.
Given the number that I need to do for the holidays, I do want to get started though. I have a number of addresses that I know are correct but there are others that I need to confirm before printing them out. If you’re like me, you don’t keep your address list up to date and you don’t print envelopes often. I have most of my addresses in Excel with columns for FirstName, LastName, Address, City, State and Postal Code. Very useful nonetheless.Īt this time of the year I find myself preparing to send out a large number of greeting cards to friends and family. In the drop-down menu that appears, select “Labels.Today’s author, Eric Patterson, a Program Manager on the Excel team, describes how to use Excel Tables as a source for a mail merge – a great productivity tool for sending out holiday greeting cards! ? Eric wrote this before the holidays but unfortunately I was out of the office and didn’t get to post this until now. 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.