Hi;
I haven't been able to get on the right track on this, so I'm hoping someone here can steer me right.
I have an Excel sheet that does a whole lot of things for me. It's a list of reports to run, with all the options they need, and an associated Distribution List to send the reports to. When run, it goes through all 100+ reports and automatically emails them out to the DL. I have a script that sets up all the new user info in the Excel sheet... but I then have to go into Outlook to create a distribution list with everyone on it who should be. The name in Excel matches the name in the outlook list.
I keep the contacts in Outlook because it's much easier to manage the lists of people there, rather than a long string in an Excel sheet.
What I'd like to do is have my Excel VBA create the distribution list in Outlook for me. I've been able to find lots of help on how to read FROM contacts, but not on how to create them. Can anyone point me in the right direction?
Thanks!
Cerv
I haven't been able to get on the right track on this, so I'm hoping someone here can steer me right.
I have an Excel sheet that does a whole lot of things for me. It's a list of reports to run, with all the options they need, and an associated Distribution List to send the reports to. When run, it goes through all 100+ reports and automatically emails them out to the DL. I have a script that sets up all the new user info in the Excel sheet... but I then have to go into Outlook to create a distribution list with everyone on it who should be. The name in Excel matches the name in the outlook list.
I keep the contacts in Outlook because it's much easier to manage the lists of people there, rather than a long string in an Excel sheet.
What I'd like to do is have my Excel VBA create the distribution list in Outlook for me. I've been able to find lots of help on how to read FROM contacts, but not on how to create them. Can anyone point me in the right direction?
Thanks!
Cerv
