A few of us are responsible for sending out a daily email. Currently, we do this manually and I'm working toward getting it automated. The recipients are fairly static, but about once a week someone asks to be added/removed/or is no longer with the company.
The following code snippet is used to determine who the email goes to:
Code: Select all
With objOutlookMsg
' Add the To recipient(s) to the message.
Set objOutlookRecip = .Recipients.Add("Email Recipients")
objOutlookRecip.Type = olTo
I'd like to host the recipients in a file in a shared location and have the code point to it to grab the recipients, rather than having the recipients in the code itself. This way rather than everyone updating their code, all that needs updated is the list.
Any help is greatly appreciated.
Thanks in advance.