BarcodeChecker 4.3

TicketCreator

Overview

Features

Ticket layout

Ticket formats

Print barcode tickets

Screenshots

Video tutorials: How to print tickets Videos

BarcodeChecker

Admission control

Scan barcode tickets with Android app Scan barcode tickets with iPhone or iPad Apps for Android & iOS

Video tutorials: Scan barcode tickets Videos

Update

Help & FAQ

Contact

Recommended by:

and many more...

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.

Print documents with barcodes or QR codes with Excel and Word's mail merge feature or send them by email with Outlook

 

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.)  BarcodeChecker software   Start BarcodeChecker and select the menu Extras: Create barcodes.

 

2.)  Create barcodes with the BarcodeChecker software

Create barcodes with serial numbers, random numbers, or characters, or import value from an Excel file.

 

3.)  Create barcodes with the BarcodeChecker software

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.

 

4.) 

Show the barcodes in Microsoft Excel.

 

Save barcodes as Excel file

5.)  Barcodes are exported to Microsoft Excel

The barcodes are now shown in Microsoft Excel.

 

6.)  Copy the barcodes into your Excel list with the names

Copy the barcodes into your Excel list with the names and save the file.

 

Print barcodes with the mail merge function of Microsoft Word

7.)  Start the Step by Step Mail Merge Wizard

Start Microsoft Word, select the Mailings tab and click the Step by Step Mail Merge Wizard.

 

8.) 

Select the appropriate document type and click Next: Starting document to continue.

 

9.) 

Select Use an existing list, click Browse and open the Excel file with the names and barcodes.

 

10.) 

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.

 

11.)

Write your document and click More items to insert the names and barcodes. Click Next: Preview to preview the document.

 

12.) 

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.

 

13.)

Format the Code 2 of 5 barcode with the font Code 2 of 5 interleaved.

 

14.) 

Format the QR code with the font MW6 Matrix, which is shown in the font list as two dots.

 

15.) 

For QR codes you must change the Paragraph settings to Spacing before and after: 0 pt and Line spacing: Single to remove the gaps.

 

16.) 

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.

 

Acrobat Professional

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.

B.) Send PDFs with the Adobe Acrobat Professional add-in for Word

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:
C:\Users\[User Name]\AppData\Roaming\Microsoft\Word\STARTUP

In Windows XP the default location for that folder is:
C:\Documents and Settings\[User Name]\Application Data\Microsoft\Word\STARTUP

 

C.) After placing the MergeTool file in the Word Startup folder the MergeTool tab is shown.

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.

 

E.) Switch to the Merge Tools-tab and select 'Merge with Attachments'

Switch to the Merge Tools-tab and select 'Merge with Attachments'.

 

F.)

Select 'Merge to Email as PDF Attachment'.

 

 G.) Select fields containing data to be used as filenames and the field containing the email addresses.

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.) BarcodeChecker software   Start BarcodeChecker and select 'Scan tickets' or 'Start server'.

 

2.)
Select 'Create BarcodeChecker file for other barcodes'.

 

3.)
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.