//How to Automate Emails to Individual Donors with Amount Donated in Email Body

How to Automate Emails to Individual Donors with Amount Donated in Email Body

This post will teach you how to write an email to your donors that records the dollar amount of donation in the email body. You will need 3 software tools to make this happen.

  • Word
  • Excel
  • Outlook


First create an Excel spreadsheet with the headers of the name of the recipient, email, and amount donated. Then verify that you have the total amount donated. If your donors made several payments you will want to consolidate and make a clean list with one row per each donor and have the subtotals summed up.

To start open up Word. Click the Mailings tab then choose Select Recipients–>Use an Existing List.

choose record source mailmerge

Navigate to select the Excel file. The spreadsheet should have a column of emails. For example: Column A is First Name, Column B is Last Name, Column C is Email, Column D is Donation.

Column A is First Name, Column B is Last Name, Column C is Email, etc.

Example of data list excel

Compose your letter by starting off with the greeting line. Then compose the body of your email message. For example you could write, “Our records indicate that your 2022 fiscal year total tax deductible donations is <<donation>>.”  Each email would be different based on the record source within Excel linked to the donor’s amount.

After writing the email make sure you include your signature. Even if you have automatic signatures setup in Outlook you still have to type the letter exactly how the reader will receive it.

compose the mailmerge

Finish the up the task by clicking the Mailings tab–>Finish & Merge–>Send Email Messages.

Write a subject that line and click ok.

subject line

And watch your screen flicker and flash as it goes to work sending out individual emails to your contact list. Make sure your Outlook program is opened up. Having it closed will only delay the messages from being sent as they will queue up in the outbox waiting for connection to Outlook.

I recommend you first to a practice test to about 3 emails with sample data. And if you are going to do large volumes of emails it would be wise to check with your IT to ensure the server requests can be scheduled to deliver properly.




By | 2018-06-07T23:48:06-05:00 December 11th, 2017|Excel|0 Comments

About the Author:

Steve Chase grew up in Dayton, OH but now calls San Antonio, TX home along with his entrepreneur wife, Erin, and their 4 sons. Steve founded Sequentia Solutions in 2017 to help small business owners grow their business with practical and effective solutions. Steve's #1 Clifton StrengthsFinder skill is Learner which comes in handy while he teaches others how to best use various business software applications like QuickBooks Online and Excel. Steve is an active volunteer leader with the Boy Scouts and treasures the lessons he learned while participating in Scouts as a youth on his path to Eagle. Steve enjoys drinking coffee, a good book, visiting art museums, and doing math problems using a brand new sharpened #2 pencils.

Leave A Comment