Hello,
I'm hoping someone may be able to help me with a bit of code I need to write for an Excel dashboard I'm creating at work.
Basically, I need to interrogate the Outlook Global Address List and retrieve details for all people who belong to a certain area (the "department" field in the address book), and list these details in a worksheet.
I've searched through various forums, but the code I've found so far just brings back all entries in the GAL, which for a company, is quite large. I have tried manipulating the code to only retrieve details for a specific department but have not had any success - it either returns no data at all, or still returns every entry.
I am using Excel 2013/Outlook 2013, although I might need to ensure this also works on Excel 2010/Outlook 2010 (if there is any difference)?
Hopefully, someone will be able to help me out with this.
Chris
I'm hoping someone may be able to help me with a bit of code I need to write for an Excel dashboard I'm creating at work.
Basically, I need to interrogate the Outlook Global Address List and retrieve details for all people who belong to a certain area (the "department" field in the address book), and list these details in a worksheet.
I've searched through various forums, but the code I've found so far just brings back all entries in the GAL, which for a company, is quite large. I have tried manipulating the code to only retrieve details for a specific department but have not had any success - it either returns no data at all, or still returns every entry.
I am using Excel 2013/Outlook 2013, although I might need to ensure this also works on Excel 2010/Outlook 2010 (if there is any difference)?
Hopefully, someone will be able to help me out with this.
Chris
