So now what we need to do is use Pages mailmerge. Let’s go ahead and make this one a little bit larger. This is the one that I want to use the classic envelope. And then what we’re going to do is create a new document a new envelope document, so I click on New Document down towards the bottom here, where we have our envelopes. So now I can quit out of Numbers, we have it set up here. If I was on the iPad or iPhone, I would be setting it up the same way, just open up Numbers, delete that first column header, and then add in your different fields. Let’s go ahead and save this, we’re going to save this to my desktop. So now my Numbers spreadsheet is all set up. But as we can see, what we have here is the full name, I also have the street, I have the city and state. Now what you do is just going to fill this data in, well, I have it in my clipboard, so I’m just going to paste it here. So I no longer need to have these two columns here. And zip, those are going to be my five fields that I’m going to use for my mailing labels. And then we need to have our street, the state, oops, city, we need a city in there. Now what I need to do is I need to create my header rows. And then when we’re looking at our format, we have headers and footer, I’m just going to select zero here, we no longer have my header column. Now what I need to do is get rid of this first column, we do not have to have a header column here. So I double click on it, we have my blank Numbers document. From here, what we’re going to do is create a blank document, we’re just going to set this up from scratch. Now what we’re going to do is create a new document. So I go down to my Mac, here I have Numbers, let’s go ahead and open it up.

So I’m looking at my Mac here, let’s first look at how we set up the Numbers spreadsheet. Let’s see how we can create a mail merge document or envelopes from a Numbers spreadsheet. We’re going to primarily look at this on the Mac, but I’ll also show you how you can do it on the iPad and iPhone. In this video, we’re going to look at how we can use Mail Merge to help us label envelopes from a number spreadsheet.

How to make address labels on mac pages