I have a form that I use to email many reports to the same group of people. Currently I use:
Dim toMailRecipient, ccMailRecipient As String
Let toMailRecipient = "ManyEmails@Removed.com"
Let ccMailRecipient = "AFewEmails@Removed.com"
Each time that I need to update the email list I have to change in in many places.
I want to know a way to use one email list for toMailRecipient & one list for ccMailRecipient and reference it so that I only have to make one update.
Please be very detailed in your response.