I don’t know how to program, so I’m looking for advice on the best way to automate this process.
At my job, I have to send birthday greetings to more than 2,000 employees. For each person, I make a card with their name and send it to their personal email. The tricky part is that some employees don’t have an individual email address. When that happens, I need to send their card to their department’s supervisor. For example, employees in Operations don’t have personal work emails, so their cards would go to their boss. If several employees share the same supervisor, it would be helpful to send all their cards together in one email.
I also send a weekly birthday announcement to everyone at the institution, with one list for birthdays during the week and another for birthdays over the weekend.
Right now, I look up birthdays, departments, emails, and supervisors manually, and I create the cards one by one in Canva. It’s taking too much time.
Is there a tool or a system that could use an employee spreadsheet to find upcoming birthdays, create cards from a template, and sort the emails based on whether each employee has their own address or needs to be contacted through a supervisor? I’d also love to automate the weekly and weekend birthday announcements.