Automated emails from date subtraction

Posted on 2012-09-17
Medium Priority
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 "bob.jones@ssi.com, charlie.smith@ssi.com, jeff.golden@ssi.com" 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
  • 2
LVL 44

Accepted Solution

Rainer Jeschor earned 2000 total points
ID: 38417997
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

ID: 38420361
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

ID: 38448925
Thank you.

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

807 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