SharePoint Designer Workflow

Functionality: The approver should receive a weekly email.  This email should contain link of an item. I cannot use Alert because I want to send a link in the email and email should go to specific Approver

Challenge – If the workflow is paused for seven days and triggers on 7th day to send an email, the challenge is if there are 10 items submitted in a week, it generates 10 instance of a workflow and so 10 emails are getting generated instead of one single email. SharePoint designer workflow runs on an Item, I need help to find how we can send only one single email even if multiple instance of the workflow are running
Who is Participating?

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

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.

kindly check the document
AlMothana AlOmari


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
Shailaja KumarCommented:
As you said, SPD workflows are designed to be a per item workflow, what you are asking for is an item level workflow and also a list level workflow. I dont see an option in SPD to implement such a business logic. You can create a custom workflow activity, plug in to SPD, that will consolidate the emails and update the status of the workflow. To know more about Custom Activities in sharepoint 2007 follow this link,
PramodSharePointAuthor Commented:
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.