I write a monthly newsletter for a firm, focusing on three separate categories, with two shortish stories in each of the three categories for (obviously) six total segments a month.
This may seem easy, but I'm looking for a way that I can quickly and easily see what I've covered in previous months. Originally I created an Excel spreadsheet, with 3 months running across the top, and the topics down the side. Then, in the respective cell, I put the topic down.
It seemed to work at first, but as the months have gone on, it has gotten somehwat unwieldy. (There's the side issue, though still important, of the newsletters I wrote BEFORE going to this new format -- I'd like to be able to throw those topics in, too) And I keep wondering if there isn't a better method. I obviously need to track the major categories, the date, and the topic. Is this a job for a database (I still have AppleWorks)? I have outlining software, I have Office, I have DevonThink.
Does anyone have any suggestions. I am a writer, and I can do the writing, but boy, some of my research is all over the place.
Thanks.