SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list of 1000+ user accounts for an application, and I need to have each user confirm that they still require access. I would like to send a form email to all of the users in the list asking them to click on on the link if they still require access, and have that link just simply update a "Required" column in the list. What is the easiest way to accomplish this?

Thanks in advance for your assistance.

Eric G

share|improve this question

In your column, create a simple number field called trigger with a default value of 0. Create a workflow that fires if the trigger field equals 1 with your link to the to update the field. Go into datasheet view of your list and update the trigger field to 1 and drag it down.

This will fire the workflow off for everyone.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.