+ Start a Discussion
sandeep kumar 1996sandeep kumar 1996 

How to write a formula for sending emails on every Friday using workflow

Hi , everyone I'm new to salesforce I have requirement to send emails to the contacts on every Friday using workflows can anyone tell me how to write a formula for it
Pankaj MehraPankaj Mehra
Hi Sandeep,

Create a field of type date on Contact and this field contains the date of coming friday when record is created, use before trigger to populate it 

if(createdDate.day == 0) {
// Sunday
comingFridayDate__c = createdDate.addDays(5); 
}

if(createdDate.day == 1) {
// Monday
comingFridayDate__c = createdDate.addDays(4); 
}

and create a time triggered workflow rule that send a email on this date and 7, 14, 21, 28, 35, 42, 49, 56, 63 days after this date.

You can add max 10 time based workflow rules.

 
Akhil AnilAkhil Anil
Hi Sandeep,

You will have to setup a recurring time-based workflow for this to work. I have explained in my blog post below on how to setup recurring workflows to run everyday. In your case you just have to tweak the workflow so that it runs only every Friday.

https://force-base.com/2016/11/13/power-of-point-click-series-2-learn-how-to-set-up-recurring-time-based-workflows-in-salesforce/

Kindly mark it as an answer if that works !