get_gal.py

import csv
import re
import win32com.client as client


def get_gal():
    outlook = client.Dispatch('Outlook.Application')
    entries = outlook.Session.GetGlobalAddressList().AddressEntries
    gal = []
    for entry in entries:
        try:
            name = entry.GetExchangeUser().Name
            match_res = re.match(r'(.*) \((\d{8})\)', name)
            code = match_res.group(2)
            name = match_res.group(1)
            email = entry.GetExchangeUser().PrimarySMTPAddress
        except AttributeError:
            continue
        gal.append({'name': name, 'id': code, 'email': email})
    return gal


def write_gal_csv(gal):
    field_names = [*gal[0]]
    with open('gal.csv', 'w', newline='') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=field_names)
        writer.writeheader()
        writer.writerows(gal)


def main():
    gal = get_gal()
    write_gal_csv(gal)


if __name__ == '__main__':
    main()