How to Create a Countdown Calendar via Word Mail Merge

In this article, we would like to show you the way to create a countdown calendar via Word mail merge feature.

Now and then, there will be specific times for big events. In the imminence of the big day, say, the graduation day, excitement tends to grow and thus, to keep track of the date and days left, a countdown calendar will be a huge help. Now, instead of shopping one in store, we want to show you an economical way that is to create it on your own simply with the help of Word and Excel.

Prepare an Excel File with Source Data

  1. First and foremost, let’s prepare an Excel file with source data. Open a new Excel file.
  2. Second, insert “Date”, “Deadline” and “Days Left” data to the first 3 columns.
  3. Next, in “A2” cell, enter the date of the day the countdown calendar starts, such as “1/20/2017”.
  4. Then select the cell. Place cursor at the right-down corner of the cell and wait it turns to a cross sign. Now click and drag down through column A to fill the rest cells until the deadline date appears.
  5. And input the deadline date in B2 cell, such as “2/14/2017”.
  6. Similarly, press “Ctrl” and fill other cells in column B with the same deadline date.
  7. Now, position cursor at C2 cell. Type the equation “=B2-A2” to get the days left before the deadline day.
  8. Finally, save the file. Create Excel File

Create Countdown Calendar via Word Mail Merge

  1. First off, create a new Word file and finish designing the calendar model, such as below:A Calendar Model
  2. Then click “Mailings” tab.
  3. Next click “Select Recipients” and choose “Use Existing List”.Click "Mailings"->Click "Select Recipients"->Click "Use Existing List"
  4. Now in the “Select Data Source” window, select the correct Excel file just created and click “Open”.Select Source Data File->Click "Open"
  5. Next, click “OK” to confirm data source.Click "OK" to Confirm Data Source
  6. Then select the right table and click “OK”.Select the Right Table->Click "OK"
  7. And place cursor at the position where data go. Click “Insert Merge Field” under the “Mailings” tab.Click "Insert Merge Field"->Choose Field One by One
  8. Insert the right field to its location.Results of Inserting Fields
  9. Now if you want to save paper, you can click “Start Mail Merge” icon, still under “Mailings” tab, and choose “Directory”. This action allows you to create multiple entries in one paper sheet.Click "Start Mail Merge"->Click "Directory"
  10. Next, click “Preview Results” to check the calendar.Click "Preview Results"
  11. After it, click “Finish& Merge” and choose “Edit Individual Documents”.Click "Finish&Merge"->Click "Edit Individual Documents"

Here is what you are likely to get:Countdown Calendar

Fix Word Errors

As a word processing software, Word’s wide and dynamic features have won it millions fans worldwide. What’s more, people end to use Word to deal with pictures and other seemingly impossible stuff. However, the result is not always pleasing. Sometimes, a single mishandling can lead to severe file loss. To address such a calamity, a Word data damage repair tool is badly needed.

Author Introduction:

Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including damaged Excel recovery tool and pdf repair software products. For more information visit

2 responses to “How to Create a Countdown Calendar via Word Mail Merge”

  1. Hallo,
    ich möchte eine Excel Tabelle generieren, wie ich z.B. auf dem laufenden gehalten werde.
    MA XY hatte am 16.05.2024 eine Unterweisung und die nächste wäre spätestens am 15.05.2025.
    können Sie mir bitte erklären bzw. eine Vorlage zukommen lassen in dem dieses Countdown farblich ersichtlich ist.
    So das ich zeitnah eine Folgeunterweisung durchführen kann.

Leave a Reply

Your email address will not be published. Required fields are marked *