Tutorial on How to Merge Labels
- 1). Use Open Office to merge labels by clicking "File," "New" and "Labels." Click "Database" and choose the source. Select "Table" and choose a table format. Click the "Database Field" and choose the type of field the data represents. Click the "Brand" menu item and choose the label brand from the list. Click the "Type" drop-down box and choose the type of label for the brand chosen, listed on the back of each label sheet. Click "Options" and choose "Synchronize Contents." Click "Setup" and choose the printer the labels will print to. Click "Print All" and click "OK" to print the labels.
- 2). Use Microsoft Outlook 2007 to merge labels by holding the control key on the keyboard and clicking each contact to merge. Click "Tools" and "Mail Merge." In the "Merge Options" field, click the "Document Type" drop-down box to select the document format and choose "Labels." Click "OK" to export the documents to form a data source. Click the "Setup" button and select the label brand listed on the package. Click "OK" and click "Close." Insert the type of fields the source data are categorized as by clicking the "Insert Fields" button. Click "OK" and "Print" to print the labels on the label sheet.
- 3). Merge labels using Microsoft Word by clicking "Mailings" on the tools menu. Click "Start Mail Merge" and choose "Step by Step Mail Wizard." In the right window pane, select the document type and click "Next." Choose the type of label from the list, which may be found on the product package. Press "OK" and select "Next." Click the data source in the window and choose "Get Data." Click the type of printer, the type of label and the label number in the corresponding labeled fields. Click "Insert Merge Field" and choose the type of field the data represents. Click "OK" and choose "Merge." Click "File" and "Print" to print the merged document.
