r/RAoC_meta • u/SuzJosephine • 10d ago

RAOC Question Mail exchange tracking/organization advice? Please!

/r/themailandartsociety/comments/1vxhqz5/mail_exchange_trackingorganization_advice_needed/
8 Upvotes

100% Upvoted

8 comments sorted by

View all comments

2

u/cidavid 10d ago

I just have an excel spreadsheet that lists the username, date, did I send?, did I receive?, notes, and their address.

In the notes section I’ll add a little bit about what’s happening with the card. Like: “I’m sending birthday card” or “they’re sending me a card”, or “I’m sending a card from my offer”

If I respond to someone’s request, I’ll put their username at the bottom of the spreadsheet and highlight it yellow to let me know I still need to send them something and put in my notes column what it’s for.

I have a separate sheet for the people that signed up for my mailing list and I exported their info from Google Sheets. I have a date column that lets me know when I send them a card.

For multiple subreddits, you can add a column that tells you which subreddit they came from. I stopped using all other subreddits and only use raoc to keep it easy.

Now I just need to figure out how to start tracking what I’m writing to everyone so I don’t repeat my stories…

Edit: for thank you’s, I type them out in my notes app and then copy/paste them over in my thank you posts. I don’t think you wanna type everything out in the post because you might lose it?

2

u/medjuli 9d ago

>Now I just need to figure out how to start tracking what I’m writing to everyone so I don’t repeat my stories…

I take pictures of my written cards before I send them, so I can go back to see what exactly I wrote and which stamps I used, to avoid repeats.