workflow email ques, does a condition need to be written? so i can change the email address for different people i need to send depending. what does the condition start with. i only have one form but on send email in workflow it can only go to one place. but i need a choice to change email addresses somewhere without going back into the back end all the time.

Add a new worksheet to you workbook. It will contain the list of email addresses for each country. Call the new worksheet “CountryEmail”. 2. In the “CountryEmail” worksheet, enter “Country” in the header of the first column. Enter “Email” in the header of the second column. 3. Enter country names and email addresses to fill in the new worksheet. 4. Open your app in the Editor and add the new “CountryEmail” worksheet as a table.

On the Data > Columns pane open the new “CountryEmail” table and make sure the “Country” field is the key of the table. 6. Update your form to allow the user to enter a country name in a new field called “Country”. 7. In the Editor, open the table containing you form and make the new “Country” field a “Ref” to the “CountryEmail” table. When the user fills in the form, they will be asked to select one of the county names from your “CountryEmail” table. 8. In your workflow rule enter [Country].[Email] in the “To” property.This will take the value in the “Country” field of your form and use that value to find the appropriate row in the “CountryEmail” table. It will then use the value in the “Email” field of that row as the email address.