I am a parent of a teen who goes to a large school (almost 3000 students). Last year, I started sending out a weekly email to some of the parents with a list of the events at the school.
The way I collected this data was time-consuming. I downloaded and printed calendars for each sport and club that I could and put them in a binder. Each week I would find the events for the upcoming event and type it into a word document. Then I would visit the school's website and check the announcements and counselors' web pages for events and add them to the word document.
I copied the word document into an email message and sent it out in batches. (I had less than 125 email addresses.)
The people who got the email liked it and the school wants to expand the list. We are looking at Constant Contact as an option. (If anyone has an opinion on that, I would like it!)
Here is short sample of what I would send out:
THIS WEEK’S CALENDAR:
-2:45 PM, Student Council Meeting
-6:00 PM, Special-called Board Meeting: Spotlight Awards
-7:00 PM, Dazzler Booster Club Meeting
-6:30 PM, Auto Tech Awards Night, Commons
-5:30 PM to 9:30 PM, AFJROTC Pot Luck Dinner and Awards Program
THIS WEEK’S ATHLETICS:
-7:00 PM, Varsity vs Georgetown High School at Georgetown (2211 N. Austin Ave.), Regional Play-offs
-7:00 PM, Varsity vs. Georgetown at Ridge
-12 noon, Varsity vs. Georgetown at Georgetown (if needed)
-Athletic Booster Club Casino Night at Crazy Frogs
-Seniors Awards Program
My question is, how could I do this more easily? And would Excel or Access work?
Most of the lists were in Word documents, but each one was formatted differently.
What I envision is that I could import the information into a program and then do a sort or search for the events that fall within the coming week.
And maybe bleeping computer isn't the best place to ask this question.
Any help would be appreciated!