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