how to print address labels from excel office 2016

A dialog will appear asking for the range of cells containing your addresses and whether your table has headers.

On the Insert Tab, click on the Table button.

Select a cell within the range containing the addresses, such as cell B2.

The first step is to create a Table from the list of addresses. 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. 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.

How to print address labels from excel office 2016