QR Barcodes with Mail Merge Follow

Not everyone is using Campaigns to send their event invitations out, and until now that means that these users were unable to make use of QR Barcodes in their invitations.

Luckily a tech-savvy user (Editor's note: Thanks Amgad!) has found a way to include QR Barcodes in a Microsoft Word generated Mail Merge document.  This can be used for printing invitations or sending them out like in CMD using the Adobe Pro and Microsoft Word.

The below guide covers how to use eContact to export your data to Excel for use in Mail Merge with QR Barcodes.

Requirements:

  • Export Event Data to Excel
  • Microsoft Word Invitation Template
  • Adobe Professional for use in Mail Merge as PDF

 

Works for CMD Exports too!

The following guide can also be used for CMD exports using the "Individual Inquiry" and the "BarcodeIdentifier"

 

Guide

1. In your eContact Custom Export, make sure to include the "Participant Barcode Identifier" field in addition to your standard fields like Salutation, First Name, Last Name...etc

mceclip0.png
2. Export to Excel.  

3. On your Word Template,  and after you connect your Excel Data Source for the Mail Merge, include the "Participant Barcode Identifier" field on the Word Template.

Note: It is better to have it placed and displayed under where you want the QR Barcode, but if you want it hidden, you can change the color of it to match the background color to hide it.

 
4. Place the cursor where you want to place the QR Barcode, and press Ctrl+F9  
5. This will create { }  

6. In between the 2 brackets, place the following code: 

 

MERGEBARCODE Participant_Barcode_Identifier QR \s 70 h\ 100 \f 0xC7751B

 

where "Participant_Barcode_Identifier" is the Merge Field Column Name from Excel containing the Barcode numbers.

 

 { MERGEBARCODE Participant_Barcode_Identifier QR \s 70 h\ 100 \f 0xC7751B }

 

 

mceclip3.png

CMD Tip!

You can do the same in CMD, but you would use the "BarcodeIdentifier" field from your "Indivdivual Inquiry" in your Word Template

7. It should look like the following:

mceclip1.png

 

8. Right Click on the field mceclip3.png
9. The following menu will appear

mceclip2.png

 

10.  Select Update Field  
11. It will look like the following after: mceclip0.png
12. This is how the QR Barcode will look like if you don't do any changes.

mceclip1.png

 

13. If you want to change the color and/or the size, you can right click on the merge field mceclip0.png
14. Select "Edit Barcode"

mceclip2.png

 

15. Click on Advanced

mceclip3.png

 

16. The following screen will appear

mceclip4.png

 

17. You can change the Scale and the Foreground Color

mceclip5.png

 

18. This is how the QR Barcode wiil appear after. mceclip6.png
19. From this point, you can use your regular process to send invitations with Barcodes (using Adobe Mail Merge)  

 

    

     

   

    

   

 

   

 

    

   

 

 

 

 

 

 

Comments

0 comments

Article is closed for comments.