Cart
Support
Contact Us
FAQ
Customer Login
User Manuals
ActiveX Control
Code 128 Fonts
UPC EAN Fonts
Code 39 Fonts
Interleaved 2 of 5 Fonts
OnLabel
Video Tutorials
ActiveX Control
Barcode Fonts
OnLabel
Buy Now
Specials
BarCodeWiz Bundle Special
Barcode Control and Add-ins
ActiveX Control
Barcode Fonts and Add-ins
Code 128
UPC EAN
Code 39
Interleaved 2 of 5
Barcode Label Software
OnLabel
Barcode Controls for .NET
Barcode Control for ASP.NET
Barcode Control for Windows Forms
Upgrades and Renewals
Download Trial
Barcode Control and Add-in
ActiveX Control Trial
Barcode Fonts and Add-ins
Code 128 Trial
UPC EAN Trial
Code 39 Trial
Interleaved 2 of 5 Trial
Barcode Label Software
OnLabel
Barcode Controls for .NET
Barcode Control for ASP.NET
Barcode Control for Windows Forms
Products
Barcode Software Comparison
Barcode Control and Add-in
ActiveX Control
Barcode Fonts and Add-ins
Code 128
UPC EAN
Code 39
Interleaved 2 of 5
Barcode Label Software
OnLabel
Barcode Controls for .NET
Barcode Control for ASP.NET
Barcode Control for Windows Forms
Home
Barcode ActiveX Control
Barcode labels in MS Word 2016, 2013, 2010, or 2007 Mail Merge
Barcode labels in MS Word 2016, 2013, 2010, or 2007 Mail Merge
Download Trial
Buy Now
Barcodes in Excel
Install Barcode ActiveX Add-in in Excel
Barcodes in MS Excel
Creating Sequential Barcode Labels in Excel
Add Supplemental Text to Barcodes in Excel
Extract Barcode Images from Excel
Create Dynamic Barcodes using LinkedCell in Excel
Supplemental Text in Barcodes using LinkedCell in Excel
Barcodes in Excel with VBA
Barcodes in Word
Install Barcode ActiveX Add-in in Word
Barcodes in MS Word
Print a sheet of identical barcode labels in Word
Barcode Labels in MS Word 2016, 2013, 2010, 2007 Mail Merge
Barcode Labels in MS Word 2003 or older
Two Barcodes Per Label in Word
Adding Text Above and Below a Barcode
Barcodes in Word with VBA
Barcodes in Access
Barcodes in MS Access
Barcode Labels MS Access
Adjust Font Name and Point Size in Barcodes in MS Access
More Tutorials
Barcodes in MS VB.NET and C#
Barcodes in MS VB6
Barcodes in MS Visual C++
Barcodes in Adobe Photoshop
Silent Command Line Installation
User Manual
Barcode Types (Symbologies)
Code 39 and Code 39 Extended
Code 128 A, B, C, and Auto
GS1-128 (UCC/EAN 128)
Interleaved 2 of 5
Standard 2 of 5
Code 93
Code 11
Codabar
MSI Plessey
UPC A
UPC E
EAN 13
EAN 8
Intelligent Mail
PostNet
RoyalMail
PDF 417
DataMatrix
QR Code
Properties
BackColor
BackStyle
Barcode
BarcodeColor
BarcodeTextColor
BarcodeTextFont
BarcodeTextVisible
BarcodeTextPosition
BarcodeTextStretch
BarHeight
BearerBars
BottomText
BottomTextAlignment
BottomTextColor
BottomTextFont
BottomTextVisible
ControlAlignment
ControlAutoSize
DataMatrixSize
LinkedCell
OptionalCheckChar
Orientation
OutlineColor
OutlineStyle
OutlineVisible
OutlineWidth
Padding Left/Top/Right/Bottom
PDF417Columns
PDF417ErrorCorrectionLevel
PDF417RowHeight
PDF417Truncated
Picture
QRCodeErrorCorrectionLevel
QRCodeSize
QuietZone Horizontal/Vertical
Symbology
TopText
TopTextAlignment
TopTextColor
TopTextFont
TopTextVisible
UnitOfMeasure
VerticalBarTextEntry
WideToNarrowRatio
XDimension
Methods
CopyToClipboard
CopyToClipboardAsWMF
GetStream
LoadProperties
SaveAs
SaveProperties
ShowProperties
Verify
Events
Click
DblClick
MouseDown
MouseMove
MouseUp
Resize
Licensing
License Agreement
Distribution & Developer License
Barcode Labels in Word usign Excel Data
This tutorial shows how to create barcode labels in MS Word Mail Merge.
Step 1. Start Mail Merge
Open the
Mailings
tab and click on
Start Mail Merge > Labels...
Step 2. Select Label
Select the label format you would like to use. We are using Avery 5160 Address Labels here.
To create your own
custom label
, click on
New Label...
instead.
Step 3. Select data for the label
Click on
Select Recipients
>
Use Existing List
and select the Excel file you would like to use.
Select the Excel file
Our Excel file simply looks like this:
Click OK to open Sheet1 (the default setting here).
Step 4. Insert Fields
Insert the merge items into the
top-left label
, as shown.
Step 5. Add Brackets around barcode field
Surround the barcode text field with square brackets.
Any text field surrounded with brackets will be c
onverted to barcodes
.
Step 6. Copy data to all other labels
Click on
Update Labels
to copy the fields into the other labels on the page.
To center, click Ctrl+A followed by Ctrl+E..
Step 7. Complete the Merge
Open the
Add-Ins
tab and click on
Convert All
to finish the
Mail Merge
and create the barcodes.
Barcode labels are created in a
new document
. You may print or save the document now.
Copyright © 2000-2019 BarCodeWiz, Inc.
|
Privacy Policy