Include barcodes to labels

You can produce labels with barcodes using DisplayBarcode and MergeBarcode. In this example, we’re utilizing numerous MergeFields, so we’re showing how to do it with DisplayBarcode.

If you want just a barcode with a hard coded worth, just utilize DisplayBarcode. For information and examples, see Field Code: DisplayBarcode.

These actions use an Excel spreadsheet as the information source for the labels. The combine creates labels with the human readable name and address, and a Code 128 barcode below with first name, last name, and city for maker reading. The field names are special to whatever Excel data source you’re utilizing. The ones here are just examples.

For standards on creating a spreadsheet with a mailing list, and more details on mail merges, see Produce and print mailing labels for an address

list in Excel. Keep in mind: Field codes and barcode types are not case sensitive.

1. In Excel, prepare your worksheet, and name the range. For more details, see Create and print mailing labels for an address list in Excel.

2. Go to Mailings > Start Mail Merge >Labels.

3. Choose a label supplier and product to utilize. If you don’t see a list of label vendors, choose Choices.

   If you don’t see your product number, choose New Label and configure a custom-made label.

4. Select OK.

5. Link the information source in Word.

   1. Go to Mailings > Select Recipients.

   2. Select Existing List, and pick your Excel file.

   3. If you get the Confirm Data Source dialog, choose Program all, and after that select MS Excel Worksheets by means of DDE (*. xls).

   4. Choose the called group.

   5. If you require to, select Mailings >Edit Receiver List and get anyone you do not want in the list.

6. Click or tap in the first label of the file.

7. Put in an “AddressBlock” on the top of the label. For more details, see Produce and print mailing labels for an address list in Excel.

8. Press Go into, and after that press Ctrl + F9 to open a Field.

9. Type DisplayBarcode”. Include the quote.

10. Press Ctrl + F9, and type MergeField FirstName.

11. Move your cursor outside the ideal curly brace, and press Ctrl + F9 once again.

12. Type MergeField LastName and move cursor to the right again.

13. Press Ctrl + F9 and type MergeField City. Move the cursor to the right outside the curly brace.

14. Type an area and a quote, then the barcode type, and any switches like” Code128 t h 1440 |. End with a vertical bar.

15. Your code needs to look like this:

    DisplayBarcode” MergeField LastName MergeField City” CODE128 t h 1440

16. < img src="https://support.content.office.net/en-us/media/3a769a22-393c-4dbe-8c0b-558578c87e6f.png" alt="A mailing label with AddressBlock and barcode fields"/ > Select Mailings > Update Labels. The other labels on the page ought to be filled in.

17. To test your merge, choose Sneak peek Outcomes.

Include barcodes using the DisplayBarcode field code, including QR codes, to labels that you make in mail combine.