In step one, we choose "Labels" and click Next in step two, you want to say you want to "Change document layout" and click Label options, and figure out what kind of labels you have. Now, in Microsoft Word, we're going to start with a blank document we're going to go to Tools Letters and Mailings and say that we want to do a Mail Merge and it brings up a six-step process. We can actually close out of Excel and go over to Microsoft Word. So I'm going to select all of that data and create a named range here- click in the name box, type "Data", and now the first row of the name range has the headings. Now, we could delete that nice title up there, or instead just create a named range.
The first thing, that data in Excel has to have the headings in Row 1. People say, "Why don't you write about this in your books?" And I say, "It's real simple, it's not an Excel problem it's a Word problem." Go find and see if he puts it in his books.īut let's talk about it since the data starts out in Excel and I'm getting questions about it. You might want to be sending out the holiday cards, and if you already have your customer list in Excel, we can take that data and create labels over in Word. Well, we're getting close to the holiday season. Hey, alright, welcome back to the MrExcel netcast, I'm Bill Jelen.
0 kommentar(er)
