Dynamically merge images, QR Codes and Barcodes
You can mail merge any image (including QR Codes and Barcodes) into your personalized emails or letters. The image needs to be accessible from a public url. You can even specify a new size for the merged image. This is ideal to generate certificates, application forms, marketing campaigns, direct customers to you business location, download apps, direct customers to a social media page or website and much more.
Merged Email or Letter
How to do it?
The column name in your Google Sheet containing the image URL should be tagged with the value <img> (for example "<img> Photo" as shown in the image below).
If the image is in your Google Drive get the URL as follows:
Right click the image and click ‘Get shareable link’.
Copy the link and paste it in your Sheet as shown in the image below.
Insert the *|<img> Photo|* merge field into your Google Document template or Email Body just like you would with any other merge field.
Hit the Merge button as you're good to go!
Can the original image be resize?
Yes. You can set with width and height in pixels within the <img> tag.
For example the following column header <img|200x100> Photo would resize the image width to 200px and height to 100px for all the images within that column.
If you change the image size in your column header within Google Sheet you also need to change the size entered in your *|merge field|* within your template (and vise-versa).
How can I generate QR Codes?
You can use an online service which generates a QR Code image from a URL. For example you can use Google Charts QR Codes as follows:
QR Code URL
Merged QR Code Image
How can I generate Barcodes?
You can use an online service which generates a Barcode image from a URL. For example you can use barcodesinc.com as follows: