How I used Conga Composer, Microsoft Word Mail Merge, and some elbow grease to conditionally show/hide tables (and why you might want to, too!)
For the month of March, I'm challenging myself to write a weekly "Listicle" style article for the different communities and audiences that make up the TDAA readership. No matter how technical this blog veers, it is and always has been my way of writing love letters to social movement organizers. This is my core motivation for learning data/tech and for writing at all! So my first post is dedicated to you ❤
Today, I want you to "meet" Septima Clark. When I think about bad ass, behind the scenes, stalwart, visionary, get-shit-done program and operations leaders from freedom movements of the 1960's, I think of her. Part two in my "Civil Writes" series.
In this installment of Dear Spreadsheet Whisperer, we use pivot tables, VLOOKUPs, and a mail merge to send top notch donor acknowledgement letters. Plus, gifs and cat memes!
This is the third installment in a series called "The Mail Merges Are Alright" featuring the National Student Walkout and the mass-email sending tool, GMASS.
Read on, for a tutorial and step-by-step instructions about how to Mail Merge a fundraising letter using Microsoft Word and Microsoft Excel. Next week, we'll cover merges using Google Drive - part of an on-going series dedicated to Mail Merge for Changemakers.
The Mail Merges Are Alright: a mini-series dedicated to using Mail Merge to fuel social movements.
In this post: anatomy of a Mail Merge and why changemakers should embrace the tool.