Chapter Info List using Excel
Our alumnae chapter keeps member information, who has paid dues & event attendance in an excel file. It usually is kept up by the Secretary & Treasurer and the Pres keeps it as well.
We mail a list of events to all our local alumnae. We also include a tear off slip to update their information & how to pay dues. If a gal wants to, the slip & dues get sent to the Treasurer. We're running into a problem however. It's easy for our members to just send their check & info to one address but it's not easy for the officers to keep this information updated. All thruout the year the Treasurer gets checks & slips. She then emails the Secretary an updated list of the master info list adding who's paid dues & snail mails the slips as well. The Secretary than enters the personal contat info from the slips. We're either emailing different updated versions of the chapter info list back and forth and sometimes someone doesn't have the most recent list. I thought about including 2 envelopes (with postage!) so that the check & info can go to the different addresses but that sounds like too much.
Does anyone have a more efficient idea for this exchange of information?
|