Automatically insert email address
Hello - can anyone help with a scripting issue?
I have a field in Layout A which has a drop down menu to select the name of any specific account manager from a list.
I would like to set up a field in Layout B which automatically inserts the selected account manager's email address for whichever is selected.
Have you any idea how this could be done? I guessed that I should create a new drop down list with all the email addresses and then set up a script to select say, 'John B''s email address if 'John B' is selected in Layout A.
I have no idea how to do this though - any help would be much appreciated.