Convert URL to QR Code Data

You can use the Command window and the following syntax to create an Excel document. You cannot use the Export window or export to a Text file as the QR Code contains CR/LF characters.

You can open a database that contains the URL String you want to convert to a QR Code.

Run this command:

SELECT *, padr(oPrintBc.QRCode(userpcqr,0),240) as qrcode1,padr(substr(oPrintBc.QRCode(userpcqr,0),241),240) as qrcode2 FROM ALIAS() INTO CURSOR myresult READWRITE COPY TO ("c:\test.XLS") TYPE XL5 USE

SELECT *, padr(oPrintBc.QRCode(userpcqr,0),240) as qrcode1,padr(substr(oPrintBc.QRCode(userpcqr,0),241),240) as qrcode2 FROM ALIAS() INTO CURSOR myresult READWRITE
COPY TO ("c:\test.XLS") TYPE XL5
USE

In the above command, change the userpcqr to whatever field name that your QR Code URL is in. Then you can open Microsoft Word and create a Mail Merge using the test.xls file that was created and use the new "qrcode1" and "qrcode2" fields right next to each other (the qrcode1 field contains the first half of the QR Code and the qrcode2 field contains the second half). Apply the "IDAutomation2D" font in whichever Font Size that will scan.

« Back to Tech Notes

New to the
Mailing
Industry?
More Info

Professional Services
More Info

AccuZIP’s Professional Services Team has been a great resource for helping me launch Informed Delivery campaigns for my clients. I am a small direct mail marketing agency specializing in helping my clients find and retain new customers with direct mail. Informed Delivery is the best thing the post office has come up with in my 30+ years in the business. However, just like everything else with the post office, they don't make it easy. AccuZIP has made doing these digital campaigns very simple. I have analyzed campaign results and found the price per click through to the client's website less than an Adword campaign. I am looking forward to working with AccuZIP and their entire Professional Services Team with more clients and campaigns.

S.R., Raleigh, NC