Create Invoice in Word from Excel Data for Facilities Effortlessly

Create invoice in word from excel data for Facilities

I'm going to show you how to create labels from a list that you have in Excel the first thing we need to do is we need to open up a Word file so here we have our word file and then we're going to go to the mailings tab on the word document and we are going to start mail merge and we will select labels okay and then it comes up with a dialog box asking you for the type of labels that you're going to select and let's select these ones that we already have you'll you'll be able to find your your labels by they go by brand and then they hand go with a number that's printed on the bottom so let's just select these ones that we have and they'll say okay and so now you have your labels so what we're going to do is we're going to go then go and select select recipients and we're going to use an existing list and what we're going to do is we are going to select our list from our documents and our labels are our names are on sheet one so let's we have that one selected so let's go okay okay so now what you're going to do is you are going to insert merge field and so now the first thing that I want to have on my label is I'd like to have the first name so let's go first name and then go insert and now let's go close you need to put a space in between your first name and your last name because you if you insert them directly they will be right on top of each other so let's go now let's go insert merge field again and let's select last name we'll go insert and then we'll go close again and once again you need to press ENTER and you're going to go insert merge field and you're gonna select a dress and then you're going to go insert and then you're gonna go close and you're gonna go enter and insert merge field and you're gonna select City so let's say that that's all we needed on our labels so we're happy with that so what we're going to do is update labels and now it's going to copy the same format onto all of your labels now what I would I suggest you do just for the fact that you can fix anything that's not right is we're gonna go finish and merge and you're gonna drop down the list arrow here and you are going to edit individual documents and it's gonna let you suggest how many you want you want to do so I'd say you go thirty at a time because 30 is the number that normally fit rips that normally fit on a page so I'm going to go one two thirty it'll go okay so there you have your labels completed for you and all you need to do is print them out now if you want to go and do the ones after that you would just click that again you would click this and go for example thirty to sixty and you keep doing that so that's how you create labels from Excel an excel list please subscribe