Here are the steps:

  1. Create a birthday wish template:

Go to Settings->Setup->Customization->Templates->Create a template for Leads/Contacts. You have three options to create birthday templates.

(a)Pre-defined templates: Find a few pre-defined birthday templates from Create a template -      >Celebration.

(b)Customized templates: Find a few basic models from Create a new template -> Basic   

            (c)Customized templates using HTML: Go to 'Insert HTML' option on the top right corner in the template gallery. Add or edit your code.   


2. Create a workflow to automate sending the birthday greetings.


a) Go to Settings->Setup->Workflow rules->Create a rule for Contacts.

b) Define the time and date on which the workflow must be triggered, and pick the Date of Birth field.

c)Choose the date of execution as  Date of Birth field

d)Set the Execution cycle as Every year.

e) Set the "Which records" to “All records” (Or define specific groups and choose to send birthday wishes to that specific clientele ( - Locate Set rule criteria)


3. Define an action to trigger emails to customers on their birthdays.

a) Go to Instant action->Send alerts->Choose the birthday template just created->Email recipient is “Contact/Lead: email and save the workflow. This automation rule sends greetings to your contacts every year on their birthday. 



2. Personalize emails to important clients by creating a custom view showing upcoming birthdays. This is done using formula fields. Let me walk you through the steps:



1. Go to Setup->Modules->Contacts. Drag and drop a Formula field and paste this in the expression and name it as “Month of Birth” and save the formula.

Month(${Contacts.Date of Birth})

This formula extracts the month of the date of birth and updates it in this formula field.

Then, drag and drop another formula and paste the below expression and name it as “Day of birth” and save the formula and the layout.

Dayofmonth(${Contacts.Date of Birth})

This formula extracts the day of the date and updates it in this formula field.

Similarly, consider the above image as reference and create another formula using Dayofmonth(${Contacts.Date of Birth})


2. Go to Contacts module—>List view drop down at the top left—>Create view.

3.  Give the criteria as “If “Month of Birth” is 1 and name this view as January and add Day of Month and Month of birth columns in the view. 

3.Sort the day of the month in the ascending order.

Now, all the birthdays that fall in January is listed in this view. Create 11 other views for each month. If you feel the custom views are flooding the drop down, just edit this custom view on the 1st of every month and change the month of birth criteria alone. If you have any queries on this, do leave a comment below. Will be happy to help you with it!