Current Infrastructure: SharePoint 2010 Standard (RTM)
My Question: Can the community advise me if it's possible to store an email address as a variable within an SPD Workflow?
Scenario: My scenario is that I've inherited a workflow solution that generates an email for specific people in the business depending on a name selected in a dreop down (choice) column within a custom list. There are then lots of else-if branches which generate the same email template to different people.
This already looks like a maintenance nightmare, so I'd like to redesign the workflow logic so that there is only one step (the email generation) but instead of editing blocks of Else-If steps to be sent to different people, the workflow will populate the email template with the addresses of the required people.
My possible options: I'm thinking I can do this two ways: -
- Keep the selection field with the drop down names and find a way to resolve these to email address
- Change the name selection to a People / Group Look-up
My preferences are to keep to option one, as I'd like to limit the names that can be selected as recipients, which I believe I'd lose with Option 2.
Any options that I may have missed, or any elaboration on the above would be appreciated.