I am extremely new at SharePoint Designer. That being said, I need to set up a work flow to send an email to when a data is added to a field in a list. The email address would come from another list on the same page. We have a program where you choose the office and plant to send issues. Both are drop down and are in a list with an assigned email address. I did not create this. When the office creates the original issue for the plant an email is sent to the plant. There is a response item in the list. My manager would like a email sent back to the office when the plant enters a response. Any help would be greatly appreciated. I have tried to created the workflow and have been unsuccessful.
This is the work flow
The emails addresses would not go in the list without hyperlink. But the work flow is Lookup as text.