Contact list and look up table
I am trying to set up automated alert to an area manager that is associated with certain stores. (Several Stores and several managers) This information is driven by forms and the only information that is chosen ( for this part) is the store name.
I have managed to create tables and formulas that then auto populate the Area Managers name.
However i cannot populate the information into a contact list column. this in turn is not allowing me to automate alerts as i believe you can only do this via a contact column
Is there any thing i can do?
Any help would be greatfully received.
Thank you for reading