I have a SharePoint list called VacReg, it contains info of users and therie vacation wishes.
In VacReg I have these columns:
Title: name of the person that has a vacation wish - text column
StartTime: start date of the vacation wish - date and time column (date only)
EndTime: end date of the vacation wiskh - date and time column (date only)
Mail: mail of the person with the vacation wish - text column
Status: is the vacation wish sent to approvel, can be send, sent or approved - choice column
Approver: mail of the user that should approve the vacation wish - text column
SentDate: date in SentDate will be set when the Status changes from Send to Sent (todays date) - date and time column (date only)
I need to send an mail to the approver when the date in SentDate has passed 29 days, and that Status still is sent.
There can be more vacation wishes to the approver from diffrent user on the same day, so we need to make sure that only one mail will be sent to the approver each day, with a list of all the vacation wishes that has passed the 29 day trash hole for that day.
I also needs to send an email to the user that has a vacation wish that has passed the 29 day trash hole.
The mail to the approver should for each vacation wish contain the name of the user with the vacation wish, the StartDate and the EndDate.
The mail to the user should contain the StartDate and EndDate of the vacation wish, that has passed the 29 day trash hole.
Then I need to delete the vacation wish from VacReg.
There is more than one approver, but only one approver on each vacation wish, and a user can only have the same approver.
I need some one that can descrip in detailed steps how I do this.
Thanks.
106
Share
Report
All responses (
Answers (
