Hi Guys,
I saved my distribution list from outlook to a shared drive at work.
I have macros that send the email automatically when, in the .To = "Name Of Distribution List".
Problem is, we have many folks using same macros from different computers but do not have their distribution lists updated.
My goal is to access this one distribution list, keep it updated and place it in the .To=
How would I reference this distribution list? I've tried using the path but doesn't work. Do I need to declare an additional variable and then place that into the .To=?
Thank You
I saved my distribution list from outlook to a shared drive at work.
I have macros that send the email automatically when, in the .To = "Name Of Distribution List".
Problem is, we have many folks using same macros from different computers but do not have their distribution lists updated.
My goal is to access this one distribution list, keep it updated and place it in the .To=
How would I reference this distribution list? I've tried using the path but doesn't work. Do I need to declare an additional variable and then place that into the .To=?
Thank You
Last edited by a moderator: