Aaron wrote:Does anybody have any solutions for tracking magazine subscriptions among members of the ward? A locally managed tool would be acceptable. Ideally, I would think, we could download the data from Church Distribution -- they have the addresses, the meetinghouse locator tool can parse the addresses to each ward, and then the Executive Secretary / Magazine Representative would have up-to-date information to track and encourage subscriptions in the ward.
Any suggestions?
For my personal magazine subscriptions (not only church mags),
I would use a spreadsheet with dates of what would be the last issue.
With conditional formatting, and the function that returns the current date,
you can then have it highlight magazines whose subscriptions are about
to run out.
For a church magazine spreadsheet, you could login into your ward website
and download a csv of the members in your ward, open it, and add columns
for each of the Church Publications ( Ensign/Liahona, New Era, Friends, Church
News, etc.)
One thing you did mentioned above that I hadn't heard before was that you
could download data from Church Distribution - Do you mean that they allow
you to download subscription information of ward members ? Because I would
think that would be a privacy issue that the church would want to steer clear of.
But if so, it could greatly make it easier to track the magazines that's for sure.
- Atticus Ewig