#MERGE EXCEL DATA INTO WORD FOR LABELS CODE#
#MERGE EXCEL DATA INTO WORD FOR LABELS DOWNLOAD#

Click on the Address Block button (See Figure 6) on the Mailings tab to pick the layout of your address. You will get one set up and then the rest of the labels will follow the same format.

Next, you want to create the label itself. When you have the file and worksheet selected, your first three lines of your document will now look like Figure 5. If you are using an Access or other database, you will need to choose the table you want to import. If you are using an Excel file, you will need to choose the exact worksheet on the next screen. When you choose to Use an Existing List, navigate to the location of your file and choose it. The Excel file has a column for First Name, Last Name, Address, City, State, and Zip. For this example, I’ll choose an Excel file. You can choose from your Outlook contacts, an Excel file, a database file, or even type in your own list. On the Mailings tab, click on the Select Recipients button. You will need to choose your recipients before you can set up the labels. Once you have turned on your non-printing characters in the step above, you can see your labels more clearly.

Click on the home tab and on the show/hide button in the paragraph group. Turn on the show/hide characters to help you see the label edges. Your Word document will look about the same but it is already set up and formatted for the labels. For this example, we will choose a standard size label that is available for purchase in most office stores and online. There are address labels, filing labels, multimedia labels, and much more. On the label options dialog box, you can choose from a large variety of labels. Click on the Mailings tab and click the Start Mail Merge button. This will be your main document for the merge. Open a blank Word document and save it to your computer. For small and large businesses, creating labels can be a big time-saver. One of the best ways to start out with mail merge is to create basic mailing labels. Usually when I go through the steps with them, they realize it is much easier than it seems. In my past training classes, I have encountered many students who think it is too complicated since it involves several steps. If you are not using the mail merge feature, then you are missing out on a great tool. Get printing! If you are unsure about the process, or if you’re worried you might have made an error, try test printing the first page or two, just to double check that everything will print as you want it to.As I was getting my holiday cards ready to send recently, I realized again how useful mail merge was to create labels in Microsoft Word. For example, if you are creating address labels, you can select “Address Block”, and then match up the fields that need to be on the label with the column in your spreadsheet that has this information.ĭouble check that everything is as it should be! This is where you set out what information should be taken from your spreadsheet and how it should be laid out. Select “Use an existing list”, then browse to find where your spreadsheet is saved. This is where you link in your Excel spreadsheet.

#MERGE EXCEL DATA INTO WORD FOR LABELS DOWNLOAD#

For this you can either use a template that you have created yourself OR you can download (and save) one of our templates which are available on our website.

If you don’t have a compatible code, then you need to “Start from existing document”.

#MERGE EXCEL DATA INTO WORD FOR LABELS CODE#

A4/A5), then select the relevant code from the list of product numbers. Select the correct option under “Label vendors” (e.g. If you have a compatible template code select “Change document layout”, then click “Label options”.

The Wizard will then guide you through the necessary steps, which are as follows: For earlier versions of Word, click on the “Tools” menu, select “Letters and Mailings” and then click on “Mail Merge”.) (For Word 2007 and after, click on the “Mailings” tab at the top of the page, click on “Start Mail Merge”, then select “Step by Step Mail Merge Wizard” from the list. Start the Step by Step Mail Merge Wizard.This does tend to be slightly easier if you are using labels with a compatible template code, as these are built in to the Mail Merge function, but you can also use your own bespoke template to complete the mail merge. The template for the labels will be created in Word, but the data used to populate the labels will be drawn directly from the Excel spreadsheet. The easiest way to accomplish this is to create the labels using Microsoft Word’s “Mail Merge” function. Most people who are printing labels from Excel are trying to create address or product labels, with each row in the spreadsheet needing to be transferred onto one label. We’ve had a few enquiries asking for the simplest way to set up labels using text from an Excel spreadsheet. Or copy the link! Templates: from Excel to Word in a Mail Merge

Merge excel data into word for labels