I have a list in SharePoint 2010 that contains Active Directory users in one column and their birthday in a second column. Early in the morning of their birthday I want SharePoint to automatically send an email with predefined text. I have created a workflow with the predefined text and the condition to send an email to the user if the birthday is equal to today, but I can't get it to work. Help!!

  • Does it work when you manually execute it? If so, have you considered scheduling the workflow, something like (sp365.co.uk/2011/09/…)? Commented Oct 7, 2013 at 19:02
  • No it does not work manually either...
    – Charlie
    Commented Oct 8, 2013 at 20:28
  • Really, I tend to believe you have an issue with dates comparison before anything else. Could you elaborate more on your solution - activity used, how do you compare, etc.? Commented Oct 9, 2013 at 21:08

2 Answers 2


You can use the Pause Until workflow action. Basically you fire your workflow when the list item gets created. Then set the workflow to pause until the specified date. Once it continues, have it send the email, change the date to the following year and pause again. Here is one blog post about it: http://www.smellslikesharepoint.com/2012/06/26/sharepoint-2010-workflow-pause-until-date-and-time/


I am not very sure about why workflow failed. However, look on SharePoint Timer Jobs, you can run timer job periodically. Check SharePoint list using SharePoint Object Model and send Email message. Scheduled Job also is an option which you can give a try.

  • Which SharePoint timer job? There are many of them.
    – Charlie
    Commented Oct 8, 2013 at 18:06
  • What does this mean? "Check SharePoint list using SharePoint Object Model "
    – Charlie
    Commented Oct 8, 2013 at 20:20
  • First of all I believe that you have access to Visual studio and you can create custom solutions for your site. What I meant was creating a custom timer job which runs daily for sending email alert for birthday wishes. In the execute method of the timer job, you can put your logic such as checking the birth date of the users, sending emails etc. You have mentioned that you maintain a list for the active directory users in your SharePoint 2010. Commented Oct 9, 2013 at 3:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.