How to send automated birthday emails to employees in our company
Comments
-
Hi Mitta,
The simplest method would be to add their upcoming birthday and a workflow that would trigger an alert on that date yearly.
Would that work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
You could use concatenation to create the custom messages in combination with andrees suggestion.
Column1: Contact column with list of employees names
Column2: date column with their birthdays
Column3: First part of message. something like "Happy Birthday"
Column4: Second part of message. Something like "! We at eagleview would like to wish you a happy birthday this year! Here's hoping you have a great one!'
Column5: Post out. =[Column3]@row + [Column1]@row + [Column4]@row would look something like this: Happy Birthday Mitta! We at Eagleview would like to wish you a happy birthday this year! Here's hoping you have a great one!
Of course you can mix this up anyway you want.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives