I currently use an email array in which the email
addresses are hard coded into the script.


ActiveWorkbook.SendMail Recipients:=Array
", ", "
), Subject:="my customers Supplier Status Report " & Date,
ReturnReceipt:="False"

Is there a way to tablize the array so that i can edit it
as needed without going into the code every time a change
comes up?

Thanks!