Need to create a sharepoint workflow?

I need to create a sharepoint workflow which will send an email once every week. It has to be a sharepoint designer workflow and it should run using out of the box workflow actions. And also he workflow should run on list basis not for per item. For example. If any item in a list has status "Submitted" it should trigger a workflow. In the sense it should send only one email for all the items that have "Submitted" status and that need to be done once a week.

Have been working on it for  about a week now, I rally need help on this one!!

Thanks in advance.
bhavneet83Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

quihongCommented:
That's not possible or easily possible. Workflows are item based and can not be scheduled (once a week).

My recommended solution would be a powershell script and that uses the SharePoint object model. Run the script on your share point server once a week via the task scheduler.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RaphilassCommented:
event receivers can be run off actions to a list rather than an item. Couple of questions...
How does the item have a status change, if this is manually ie someone updating the itme, then the workflow could be triggered by an update to the item, check the status and if the status = the required value then the action can be taken.
If it is updated from another workflow, it is probably worth looking into event recievers and the item updated event.
If you want this to be an action which triggers once per week,  checks all of the list items for the status or status change to the required status this would require a sharepoint time job, or a workflow written in visual studio which re-hydrates once per week to check the list.
One thing is for certain,  you cannot detect actions on a list (not a listitme) from the out of the box sharepoint designer workflows (Although you can write custom one fo these).
If you can provide more specific description we may be able to help you find a demo or tutorial which is close to what you need.
0
JoestetzCommented:
You could use OOTB alerts to send summary emails once a week. Thats pretty much your only shot without using Visual Studio for one of many different possible solutions.
0
samer_othman82Commented:
Using sharepoint designer is fair enough for you
you should use sahrepoint designer version 2 ,
first step should be
Check if status = submited
if yes then send email
else
you should use pause for duration method ( here you should assign 7days ) which means the workflow will pause for 7 days
then in add second step contains
check if status = submited
then send email
all these functionalities can be achieved from sharepoint designer
this link is very useful and you can understand my point from here
 http://office.microsoft.com/en-us/sharepointdesigner/HA102199841033.aspx


0
bhavneet83Author Commented:
it turns out , that we have write workflow in VS
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.