Mail-merge

Word's mail-merge is suitable only for font-based barcodes. The merge data must already exist and contain the correct characters to form the barcode when displayed in the barcode font. While the data can come from any source this description assume that the data is in an Excel spreadsheet and that the font-based barcodes within the spreadsheet have already been created using the Barcode macro provided in the sample Excel spreadsheet.

A sample mail-merge group of files is provided in the msoffice\mailmerge subdirectory of the installation directory. If you are not already familiar with mail-merge techniques the description below outlines the steps needed to include barcodes on mail-merge documents.

To demonstrate the mailmerge facility create new document, select Letters and Mailings from the Tools menu and choose Mail Merge Wizard from the pop-up menu displayed. The following steps are required - at least the first time you create a mailmerge document.

1. Choose the type of document to be created (eg. Labels)

2. Select the labels sizes (eg Avery Mini address)

3. When selecting recipients, choose Browse and locate the dk2dk.xls spreadsheet, then choose Sheet1$ from the list of tables. Note that the first row of data in this spreadsheet does contain column headers - so ensure that the "First row contains column headers" checkbox is checked. All the records will be selected by default

4. Layout the first label by selecting "More items", then double-click on the database fields shown as data and barcode. Select the <barcode> shown on the top label (INCLUDING THE << AND >> CHARACTERS) and change the font to one of the barcode fonts (eg. AZTW at 8 point). A garbled barcode should now be visible. Now push the "Update all labels" button.

5. selecting "Preview your labels" will display the number of labels you selected in step 2.

6. Selecting "Complete the merge" create the complete document ready for saving or printing

If you enable the Mail Merge toolbar (by checking the Show Mail Merge Toolbar item on the Letters and Mailings menu) you can check the contents of each label by using the navigation items on the toolbar.

 

More:

Reference