I have developed an Excel spread sheet with a mail merge add-on. It tracks yearly church contributions and then provides a contributions summary for tax purposes that are sent out in January. The summary letter has the sentence “Your total contributions for the year 2014 is”
I wish to make this year to automatically update to the next year i.e. Last year’s letter said 2013. I had a popup that reminded them to change the year in the letter before running the mail merge. One person forgot and caused all kinds of problems for someone preparing the tax form.
In other words, I need a variable that always shows the preceding year date in the mail merge letter