 |
| VectorPortal |
The fellowship has a Google Workspace account for non-profits which will allow me to send out messages via a mail merge. (If I decide to get fancy with it I can set up an even add the person's name.) For the past few days I've been working on coming up with a solid contact list. The information is in one of four places, but one of those places actually has three different categories. And there's some overlap in the categories.
I started out trying to put everything into a Excel spreadsheet and only confused myself. Next I tried Google Sheets, but since I don't know much about its commands I got angry and had to walk away. Eventually I sent an email to the person who did the job last year, then went out for a walk.
Along the way another possible way to put together the list occurred to me. Back at home I manipulated the information I had and uploaded it into Google Contacts. then added categories so I can send out messages to some or all of them. I composed and sent a test message to everyone on my list by category.
When it showed up in my personal inbox I was so excited I jumped up and started dancing around!
It didn't take me long to realize that anyone who was in more than one category would have received the message more than once, so I started cleaning up the list. And I've already gotten a few automated responses that some of the addresses are not valid, so that's still more work to do.
Five years ago today: Thank God Its Monday
Argh! I kinda like doing things like that and I kinda don't, if that makes any sense.
ReplyDeleteIt does!
DeleteOrganized and dedicated, you are.
ReplyDeleteI try :-)
DeleteI love to organize stuff, but with technology I doubt I would do well without getting frustrated a lot!
ReplyDeleteI think that's why my project too so long...I would get frustrated and take a break.
DeleteThis sounds like something that you'll enjoy and end up being really good at. Cool beaners.
ReplyDeleteAnd I've already learned things I didn't know before. Yea me!
DeleteGood for you-Christine cmlk79.blogspot.com
ReplyDeleteThank you.
DeleteI am not the best with technology, but thank goodness that I have 6 grandkids that know computers very well. I use an Apple computer which is a little more difficult than what I would prefer, but I manage. Best of Luck getting everything worked out the way you need it to be.
ReplyDeleteMy kids are much more technology-savvy than I am, but I try to keep up.
DeleteI know you'll whip that list into shape in no time!
ReplyDeleteFrom your lips to God's ears!
DeleteThey tell you it's so simple to merge lists or whatever. They lie. Good luck with your emails.
ReplyDeleteI agree with your comment completely :-)
DeleteYou certainly have your work cut out for you, going into the new year. Learning new things is good for your brain.
ReplyDeleteYes, I am trying to look at the challenges as brain exercise.
DeleteGlad you figured it out. I get very frustrated when trying to do something like that!
ReplyDeleteI got frustrated, but in the end I won!
DeleteNice that you figured it out.. nothing a walk can't fix.
ReplyDeleteI've gotten some of my best ideas while walking, but the challenge is to remember them for when I get back home.
DeleteI thought I'd left a comment. Oh well...
ReplyDeleteThat's happening more and more for me too :-(
DeleteTechnology is confusing and difficult to spell.
ReplyDeleteGod bless.
Yes to both statements
Delete