[python-win32] MS Exchange address book access within Python

[Anderson, Allan]

Thanks for your suggestion and code, Tim. I wound up using the Cookbook
recipe here:
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/475179
-Allan

-----Original Message-----
From: python-win32-bounces+aanderson=opentv.com at python.org
[mailto:python-win32-bounces+aanderson=opentv.com at python.org] On Behalf
Of Tim Golden
Sent: Thursday, April 20, 2006 8:56 AM
To: python-win32 at python.org
Subject: Re: [python-win32] MS Exchange address book access within
Python

[Anderson, Allan]

| Hi, folks. I'm working with the gnatsparse.py script included with
| Bugzilla to import my company's old GNATS bug database. As this script
| appears to have been written specifically for the migration of the GCC
| project, and also as it was written for an older version of Bugzilla,
| I'm having to make some modifications.
| 
| ... it would be very convenient and result in very correct
| data if I simply looked up the addresses and names in our Exchange
| address book. I know nothing about how that might work, however. 
| 
| Is there a python module that wraps up this sort of handy 
| functionality?

I'm not sure if this is exactly what you're after (or
even roughly what you're after) but I hope it's a starting
point:

<code>
import codecs
import tempfile

import win32api
import win32com.client
constants = win32com.client.constants

session = win32com.client.Dispatch ("MAPI.Session")
session.Logon ()

filename = tempfile.mktemp (suffix=".csv")
print "Writing to", filename
f = codecs.open (filename, "w", "latin-1")
try:
  address_lists = session.AddressLists
  gal = address_lists.Item ("Global Address List")
  addresses = gal.AddressEntries
  for i in range (addresses.Count):
    entry = addresses.Item (i + 1)
    if entry.DisplayType == constants.CdoUser:
      name = entry.Name
      smtp = entry.Fields[0x39FE001E]
      f.write ('"%s","%s"\n' % (name, smtp))
      ## print name
finally:
  f.close ()

session.Logoff ()

</code>

TJG

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
_______________________________________________
Python-win32 mailing list
Python-win32 at python.org
http://mail.python.org/mailman/listinfo/python-win32