Hello,
I'm looking for a way to create 80+ distribution lists in outlook and include contacts in those groups. My data looks like the below. I would need to create a new distribution list(contact group) in outlook based off of the name in the DistList column and add new contacts to it. For example I would need to Create a Distribution list named XYZInc3 and then create four new contacts in that distribution lists (Mary, Joe, Sarah & John). After that one is created I would need EFGCorp7 created with 3 contacts(Bob, David and Sue) and so on. Can someone assist with the code that can do this?
Ideally I would like to save these down to a Public Contacts folder, is this possible?
<tbody>
</tbody>
Thank you
I'm looking for a way to create 80+ distribution lists in outlook and include contacts in those groups. My data looks like the below. I would need to create a new distribution list(contact group) in outlook based off of the name in the DistList column and add new contacts to it. For example I would need to Create a Distribution list named XYZInc3 and then create four new contacts in that distribution lists (Mary, Joe, Sarah & John). After that one is created I would need EFGCorp7 created with 3 contacts(Bob, David and Sue) and so on. Can someone assist with the code that can do this?
Ideally I would like to save these down to a Public Contacts folder, is this possible?
| DistList | First Name | Last Name | Email Address | Company |
| XYZInc3 | Mary | Wright | mary@xyz.com | XYZ Incorporated |
| XYZInc3 | Joe | Gord | joe@@xyz.com | XYZ Incorporated |
| XYZInc3 | Sarah | Gill | sarah@@xyz.com | XYZ Incorporated |
| XYZInc3 | John | Wells | john@@xyz.com | XYZ Incorporated |
| EFGCorp7 | Bob | Mill | bobm@efg.com | EFG Corporation |
| EFGCorp7 | David | Sands | davids@efg.com | EFG Corporation |
| EFGCorp7 | Sue | Lynn | suel@efg.com | EFG Corporation |
| NNNLLC2 | Gina | Jones | gina2@nnn.com | NNN LLC |
<tbody>
</tbody>
Thank you
