Print or send barcodes and QR codes with
BarcodeChecker, Excel & Word
- for tickets, name tags, invitations -
If you have an Excel list with names for which you want to print tickets, name tags or invitations with barcodes, you can use the mail merge feature of Microsoft Word to print or send these documents.
1.) Print documents with barcodes or send emails with PDF attachments, which the customers print at home (requires Outlook and Adobe Acrobat or Merge Tools (free)).
2.) Scan the barcodes at the entrance with BarcodeChecker to reject copied tickets or register the participants.
Create barcodes with BarcodeChecker
1.) Start BarcodeChecker and select the menu Extras: Create barcodes.
Create barcodes with serial numbers, random numbers, or characters, or import value from an Excel file.
Then select the barcode type. You can create linear barcodes in the formats Code Interleaved 2 of 5 and Code 39, which can be read with all scanners and smartphones, or QR codes, which can be read with smartphones and 2D scanners.
Show the barcodes in Microsoft Excel.
Save barcodes as Excel file
The barcodes are now shown in Microsoft Excel.
Copy the barcodes into your Excel list with the names and save the file.
Print barcodes with the mail merge function of Microsoft Word
Start Microsoft Word, select the Mailings tab and click the Step by Step Mail Merge Wizard.
Select the appropriate document type and click Next: Starting document to continue.
Select Use an existing list, click Browse and open the Excel file with the names and barcodes.
The imported value from the Excel file are shown and you can select the recipients. When you're done, click OK to close the dialog box.
Write your document and click More items to insert the names and barcodes. Click Next: Preview to preview the document.
One of the merged document is now shown. You can switch between the recipients with the appropriate buttons.
Note: The barcodes are not yet formatted with the required font and hence shown as text.
Format the Code 2 of 5 barcode with the font Code 2 of 5 interleaved.
Format the QR code with the font MW6 Matrix, which is shown in the font list as two dots.
For QR codes you must change the Paragraph settings to Spacing before and after: 0 pt and Line spacing: Single to remove the gaps.
Done. Now you can print the merged documents with the barcodes.
Send barcode tickets as emails with PDF attachments
You can also send the barcode tickets automatically by e-mail. This requires an Excel file with e-mail addresses, Outlook and Acrobat Professional or Merge Tools (free).
Attention! You must send the document with the barcodes as PDF attachment! You cannot send the text as email with Word, because the recipients do not have the barcode font and will therefore not be able to read the barcode in the e-mail. However, they can read and print the barcode in a PDF.
If you have Acrobat Professional (not the free Acrobat Reader) it installs an add-in in Word, which you can use to send mail-merged documents as PDF attachments.
A.) Perform steps 1-15 as above.
Press 'Merge to Acrobat PDF' in the mailings tab and send the e-mails.
Merge Tools (free)
A free alternative to send e-mails with PDF attachments is Doug Robbins' Merge Tools for Office 2007 and later.
A.) Download the Merge Tools file (MergeTools2014xxxx.dotm) from Doug Robbin's skydrive.
B.) Move this file in the Word Startup folder.
In Windows Vista and Windows 7
the default location
for that folder is:
In Windows XP the default location
for that folder is:
C:\Documents and Settings\[User Name]\Application Data\Microsoft\Word\STARTUP
After placing the Merge Tools file in the Word Startup folder the Merge Tools tab is shown.
D.) Create a mail merge document as described in steps 1-15 above. Use the document type 'letter', not 'E-mail message'. Save the document.
Switch to the Merge Tools-tab and select 'Merge with Attachments'.
Select 'Merge to Email as PDF Attachment'.
Select fields containing data to be used as filenames and the field containing the email addresses.
H.) Press 'Continue' to send the e-mails with Outlook.
Use BarcodeChecker to scan and check the barcodes
1.) Start BarcodeChecker and select 'Scan tickets' or 'Start server'.
Select 'Create BarcodeChecker file for other barcodes'.
Open the Excel file with the barcodes, select the field with the barcode as text or number, and save the BarcodeChecker file.
4.) Scan the barcodes at the door with a barcode scanner, a web cam, an Android phone, or an iPhone/iPad. See details.