Automated emails from date subtraction

Posted on 2012-09-17
Last Modified: 2012-09-30
I designed a Sharepoint site in our organization which tracks when computer software should be renewed.  I designed the site using Sharepoint Designer 2007, and worked my way through learning it on my own so I am new to Sharepoint (and workflows).

Is there a way to have Sharepoint send out automated emails when Current Date is 90 days away from the field of 'OMB Expiration Date'?  Example:  If the expiration date is 10/01/12, have an automated email sent on 07/01/12 (or whatever exactly 90 days is), to ",," saying that

In the OMB Title field in Sharepoint is the name of the software.

Example of a 07/01/12 email:
"The software (OMB Title) will expire on 10/01/12.  Please advise IT if you wish to renew or not renew this sofware.  Thank you."

Please let me know if you have any questions.

Thank you for your help!
Question by:James0903
    LVL 44

    Accepted Solution

    you should be able to create a SPD workflow which will be paused until your calculated date and send the email then:
    SPD Action: Pause Until Date


    Author Comment

    Rainer, thank you for your assistance.  

    Is there a way to have a Sharepoint workflow run automatically without user intervention?  I want automated emails be sent 90 days before a renewal date, but don't want to have to go into the Sharepoint list to change something to get the workflow to trigger or to have it run manually.

    What are your thoughts?  

    Thank you.

    Author Closing Comment

    Thank you.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
    Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now