Copy Paste: How to Journal Easily

I don't actually write with a flower-petal pen nor drink out of tea cups... I just picked the least intimidating photo of journaling I could find.

I don’t actually write with a flower-petal pen, nor drink out of tea cups… I just picked the least intimidating photo of journaling I could find. ( pc: Carli Jean / Unsplash )

I’m here to share a really easy way to start a journaling habit. It’s literally Copy Paste. But first, have you heard about the benefits of journaling? Continue reading

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!

{{Street}}


Best Regards,

Mountain Evan Chang
Founder

For detailed instructions on how to do this, check out: http://www.labnol.org/software/mail-merge-with-gmail/13289/