I have a form that sends emails when different fields are triggered. I want to assign an address list to a string by using global variables (so I can edit the list @ one location).
I tried adding this just below the "options compare database" section but it is not recognizing the address list when the email is triggered. I know the email list is formatted properly because I added it directly to the .to section and it worked perfectly. How do I declare this list globally so i can use the EmailsAddressList string anywhere in the code?
Public EmailsAddressList As String
EmailsAddressList = "email@example.com; firstname.lastname@example.org"
Thanks in advance!