Dynamically merge images, QR Codes and Barcodes
You can 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.
Template
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.
- If the image is in your Google Drive get the URL as follows:
- 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.
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:
https://chart.googleapis.com/chart?cht=qr&chs=128x128&chl=Joe Smitháé
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:
Template
