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 two lists that i would like to use to create a workflow that sends email whenever an item is created.

Here the details:

List Officers has two columns, City and Officer and there clearly are lots of officers per city. in the second list Enquiry there is one field City (mandatory), so basically i want that when a new item is created in Enquiry the workflow lookup the city in the Officers list and send an email to all the officers in that city.

Any idea on how i could achieve this? i don't have access to the sharepoint server and i don't know how to work with visual studio, c# etc. just plain SPD 2007

share|improve this question

In the past, I would have my list of Officers have one city listed and the Officer column be set to either a person/group field with multiple selections possible or a plain text multiline field where I would put in email addresses delimited by semicolons. Then in my workflow, I'd look up that particular field store it in a variable and use it in my email.

SPD doesn't give you options to store collections of data like that.

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.