Mail Merge in Gmail helps me confirm addresses quickly

gmail mail merge address confirm

When I first got shoe inventory in May 2013, I sent a pair of shoes to a customer’s old address. No surprise, they went missing. So now, when I fulfill pre-orders for Chronology, I always make sure to confirm shipping address with my customers.

A few weeks ago, as I was preparing these “confirm address” emails, I found myself copy+pasting data multiple times for each email. Surely there must be a better way! I remembered learning how to run mail merges before. You create a template in Word, then create a spreadsheet in Excel with the data to be merged. Maybe you could do this with Gmail and Google Docs too? A quick Google search proved that yes you can!

Here is my template below.

Hey {{Full Name}},

How’s it going? I have your pair of {{SKU}} inspected, packed, and ready to ship! Is this still the best address to send them to? Thanks!


Best Regards,

Mountain Evan Chang

For detailed instructions on how to do this, check out: