QR code mail merge
With codeREADr, you can export a database to QR code images, suitable for scanning on electronic displays or print. But how do you get those images to your customers? If you have MS Office 2007 or later, it’s easy to include the images we export in an email marketing message (aka a “qr code mail merge”).

NOTE:

Microsoft Outlook must be configured with a valid email account to successfully execute a QR code mail merge.

Let’s Go

First, you’ll need to log on to codeREADr or sign up for an account. Once you’re signed in, click the “Databases” tab in the site header. You’ll see a button to create a new database on the right side of the page – click it.
QR code mail merge
Now you need to add the barcode values you’d like for your database. You can manually type in each barcode value and associated response text within the “Add / View” tab. If you have more than 20 or 30 values, we recommend clicking on the “Import / Export” tab and importing a CSV file. (For our CSV formatting guidelines, click here.)
Export your barcode values as images by clicking on the appropriate button in the “Import / Export” tab. The images will be sent as a ZIP file to the email address you signed up with.
Once you’ve received our email, download the attached ZIP file and extract the barcode images. We’re going to need to specify the folder location of these barcodes in MS Office, so we’ll keep the path simple: create a folder entitled “Temp” on your C: drive, if it doesn’t already exist. Copy the extracted barcode images to that folder.
QR code mail merge
QR code mail merge
Open Microsoft Excel and create a new spreadsheet. In Row 1, write all the variables you’d like to dynamically insert into your email. One row needs to include the filename of each barcode image. In this example, we had exported a database with five values “mailmerge1, mailmerge2, mailmerge3, mailmerge4, mailmerge5”. These values are listed in column C, which we labeled as “MailMergeImages” in Row 1. Save the spreadsheet.
QR code mail merge
Now it’s time to execute the QR code mail merge. Open Microsoft Word and create a new document. Click the “Mailings” tab, then “Start Mail Merge –> Step by Step Mail Merge Wizard”.
QR code mail merge
Under “Select document type”, select “E-mail messages”.
QR code mail merge
Feel free to select any one of the options in the next step.
QR code mail merge
Now it’s time to choose your recipients. Under “Use an existing list”, click “Browse…” and select the Excel spreadsheet you just created. You’ll need to specify the rows you want to include in this email’s recipient list.
QR code mail merge
QR code mail merge
The next step is to write your email message. You can dynamically insert variables you created in the Excel sheet by selecting a database column from “Insert Merge Field” in the Mailings tab. In our example Excel spreadsheet, we included the first name and last name of our recipients in columns titled FirstName and LastName. Select these from the menu and you’ll see <<FirstName>> or <<LastName>> display in the email. These will display as the recipient’s actual name when the email is sent.
QR code mail merge
To insert your barcode image, follow the steps below.

  • Step 1: Press Ctrl + F9. You should see a set of curly brackets appear within the document. Then type “INCLUDEPICTURE” in the flower braces. Your statement should look like this:{INCLUDEPICTURE}
  • Step 2: Provide a single character space and start a double quotation. Then hit Ctrl + F9 again to open up another pair of flower braces, like so:
    {INCLUDEPICTURE “{}}
  • Step 3: Type the following – IF TRUE “C:TEMP . Now your statement should look like this
    {INCLUDEPICTURE “{IF TRUE “C:TEMP}}
  • Step 4: In this step the Mergefield will be inserted and it will be the “MailMergeImages” column. Hit ctrl+F9 again to open up another pair of flower braces and Enter the following – Mergefield MailMergeImages. Now your statement should look like this
    {INCLUDEPICTURE “{IF TRUE “C:TEMP{Mergefield MailMergeImages}}}
  • Step 5: In the final step finish the statement as shown below.
    {INCLUDEPICTURE “{IF TRUE “C:TEMP{Mergefield MailMergeImages}.png”}”d}

Important Note: All the pairs of flower braces in the above statement should be opened by pressing ctrl+F9.
QR code mail merge
Notice that this text includes the folder in which our barcodes are stored (C:Temp), the column label in which our barcode images were entered (MailMergeImages), and the file extension of our exported barcode images (PNG). If any of these variables are different in your mail merge, you need to change the expression accordingly.
Once you’re done writing your email message, you can advance to the next step and preview your barcode image embedded within the email.
QR code mail merge
Advance to the next step and click “Electronic Mail…” to send your message to the specified recipients. A dialog box will appear. The “To:” field should be the column should be the column name of the email addresses you entered in the Excel spreadsheet.
QR code mail merge
QR code mail merge

Qr  Code Mail Merge(d)!

Your email has been sent! Enjoy the benefits of paperless barcode delivery with a flawless QR code mail merge.

QR Code Mail Merge Tutorial codeREADr