I need to see the most recent people added to our In Memory section. I tried to download list but there is no field for "entered". We do not use the year deceased and the last update no good either.

Is there any other way to do this?

Since we do not record that date that the members were added, there is not likely to be a good way to get that info.

We keep a separate database where we record all the stuff that CC doesn't do, including when the deceased's status was changed on the website, which publication issues they'll be shown in, and how we verified their passing - obit, family notification, online Soc Sec death index, etc. We've had too many classmates tell us of losses only to have the classmate refute it!

We also maintain a Post Office formatted address ready to mail to, since what classmates enter on the website isn't always correct or complete. We record the source of the address update and the date we last knew it was valid, since it's not always from the website. This is why we keep asking for the CC download to have the date of contact info changes, not just profile updates.

The problem I had is that I was in the hospital for awhile (OK now) and I could not get to the database where we keep the records. I did a search on my emails and I believe I got all. Is there a way to see this by the emails that were sent?

Also, the data base is the biggest problem with have. I always kept address on Access. The problem with that is I would have to update everyone's address whenever something changed. I did this for a lot of years but now that the company that does the mail checks the address I usually do not update manually. Of course this leads to other problems. Out database of 30,000 is out of control!!!

What do people do?

God bless you, Roy for trying to keep a database of 30,000 people up to date. After viewing your site, it seems like an almost impossible task to keep track of so many classmates. I'm hoping you have some good helpers. Best wishes in getting your difficulties resolved.

Our whole database is about that big, too. I've split off the pre-1930s. We have it in Excel. I added a column with all the CC ID numbers so I can sort it and synch it up with the downloads. Then I do an automated comparison (formula =exact)of emails and addresses, especially for those where the update dates are since my last check - filter or sort. But for contact info updates it's easier to just use the email notifications as they come in since that's not included in the download. I save up about 10 at time. That's about the only thing I do for our alumni association now since nobody else wants to.

Mary,

I would not know where to begin to to that on excel. I can understand that no one wants to do it. I am the only one doing it now. I am not sure where to go from here. There has got to be an easier way.

As for In Memory I did get them from my emails.

ray

RAY,
For some reason, this thread popped up in my email today.
Did you ever get this issue resolved?
I realize this is several years old, but I did find this:

Using the Export Wizard, you can export data from an Access database to in a file format that can be read by Excel.

My database is still out of control. I am starting to look for ways to get better.
Thank you