Export Data From Excel to Make Labels

Prepare the data on the Excel assessment for the mail fusion by use clearly identifiable column headers. At the top of each one column that contains data, there would have be text typed in that explain the nature of the data in that column. This is called the column header. Examples to include "First Name," "Last Name," "Street Address" and "City". Do not use ambiguous names like "Column 1 Data."

Ensure that a separated column is used for each one element that be exported in the mail merge. Do not trust elements such as rue address, city, state and zip code in the same column. to save and end the spreadsheet.

Open Microsoft Word. Click the "Start Mail Merge" option in the "Start Mail Merge" program group, located on the sendings tab.

Click "Labels." to choose the "Continuous-feed printers" option or the "Page printers" option, then to specify which Plate to use. chosen the label supplier information of the drop-down menu, then chosen the label product number which would have be enumerated on the label packing or back of each one label sheet. Click "OK." Word create a document with the provision of the label break into leaf divided by roast lines.

Click the Microsoft Office button (the circular button bearing the Microsoft Office logo), then click "Word Options." Click "Advanced." roller down to the "General" section and click the checkbox afterwards to "Confirm file format conversion on open" to place a Control in it. Click "OK."

Click the "Select Recipients" option in the "Start Mail Merge" program group, located on the sendings tab. Click "Use to exist List."

Locate the Excel assessment file use the "Select Data Source" dialog window. Click "Microsoft Excel sheets of work via DDE (*.xls)" option of the drop-down menu, then click "OK."

Select the cell range or assessment from the Microsoft Office Excel dialog Fenestrate under the "Named or Cell Range" text. Click "OK." The labels are now connected to the Excel assessment data.

Click the "Edit Recipient List" option in the "Start Mail Merge" program group, located on the sendings tab.

Use the "Mail fusion Recipients" dialog Fenestrate to chosen individual discs by to click the checkbox afterwards to each one record you to want to to include or release the checkbox for any discs you to want to exclude. Click the titrate of each one column to change the left order enter alphabetical and reverse-alphabetical order. Change the left order by to click the "Sort" button under the "Refine recipients list", then selection your left order of the "Sort Records" tab in the "Filter and Sort" dialog window.

Filter the discs by to click "Filter" on the "Refine recipient list" tab. Use the "Filter and Sort" dialog box on the "Filter Records" tab to left the discs by name, country, region, city, zip code, etc.

Populate the labels with texts of waiting that to say where the assessment data be put on the label. each one placeholder corresponds to the data in each one column and is included in chevrons. For example, if the column Heading for a column of assessment data is "Street Address" the text of waiting that would have be put on the label in the place where you to want the rue address to to appear will read "«Street Address»". To insertion a placeholder, use the icons in the "Write and insertion Fields" group on the sendings tab to to choose a text of waiting type, set text of waiting options in the pop-up dialog box and click "OK" to insert.

Click the "Update Labels" icon in the "Write and insertion Fields" group on the sendings tab to retort the texts of waiting from the initially label to all other labels on the page.

Click "Preview Results" in the sendings tab to forecast the mail merge. Click the "Finish and Merge" icon on the sendings tab to export the data of the Excel assessment into Microsoft Word. Click "File" and to choose "Print" to copy out the labels.