Velocity Reviews - Re: Mapi Attachment method WriteToFile throws exception ...

Answering my own thread here in case someone else is interested. For
some reason CDO doesn't support what I was trying to do through MAPI,
or there's a bug or something, so I ended up using the Outlook object
model instead of the MAPI one.

To find the documentation of the object model, search for vbaol*.chm
on your disk - it'll probably show up under the office directory. In
case your file name is different, you might just search your office
dir for *.chm. The object model (javadoc-esque) makes this a million
times easier. The python code is just slightly different - here's the
(working) result.

"""
file - getvwstofile.py
opens a folder in an exchange inbox, iterates over its contents, saves
attachments on messages to disk
"""
from win32com.client.dynamic import Dispatch

s = Dispatch("Outlook.Application")
space = s.GetNameSpace("MAPI")
inbox = space.GetDefaultFolder(6)
vw = inbox.Folders[9] #open the folder i want

#now iterate over the messages
for x in range(1, len(vw.Items) + 1):
sub = vw.Items[x].Subject
sub = sub.encode('ascii', 'strict')
bContinue = 0
z = sub.find("Alert, ")
#if the subject the string i want in the subj, continue
if z != -1:
item = vw.Items[x]
attaches = item.Attachments
if attaches:
for i in range(1, len(attaches) + 1):
atitem = attaches[i]
if(atitem):
atitem.SaveAsFile("c:\\vwmsgs\\%d.html" % (x))
s = None

pcurran@intraspect.com (Peter Curran) wrote in message news:<bf49679f.0306231512.57ad4475@posting.google. com>...
> Hello -
>
> I'm getting an exception when I try to save an email attachment
> gathered from an Exchange server using Mapi and python com utils.
>
> The COM exception I'm getting back in indecipherable (to me) and I'm
> hoping that someone in this group can help me dereference the error so
> that I can move on. My code is included below - it's ugly but it
> works well other than where I try to save the attachment - maybe
> someone can use it.
>
> Is there a place where I can look up CDO exceptions? Has anyone else
> resolved this problem?
>
> The exception:
>
> File "<COMObject <unknown>>", line 2, in WriteToFile
> File "C:\Python22\Lib\site-packages\win32com\client\dynamic.py",
> line 237, in _ApplyTypes_
> result = apply(self._oleobj_.InvokeTypes, (dispid, LCID, wFlags,
> retType, argTypes) + args)
> com_error: (-2147352567, 'Exception occurred.', (17389, 'Collaboration
> Data Objects', ' [Collaboration Data Objects - [E_FAIL(80004005)]]',
> None, 0, -2147467259), None)
>
>
> The code:
>
> """
> file - getvwstofile.py
> opens a folder in an exchange inbox, iterates over its contents, saves
> attachments on messages to disk
> """
> import sys
>
> s = Dispatch("Mapi.Session")
> s.Logon()
> vw = s.Inbox.Folders[9] #open the folder i want
>
> #now iterate over the messages
> for x in range(1, len(vw.Messages) + 1):
> sub = vw.Messages[x].Subject
>
> bContinue = 0
> z = sub.find("Alert, ")
> #i only want messages with particular subjects
> if z != -1:
> item = vw.Messages[x]
> attaches = item.Attachments
> if attaches:
> for i in range(1, len(attaches) + 1):
> atitem = attaches[i]
>
> #here's the weirdness - got the attachment, but can't
> save it!
> #i've also tried atitem.WriteToFile("c:\vsmsgs\%s" %
> (atitem.Name))
> if(atitem):
> atitem.WriteToFile("c:\\vsmsgs\\%s" %
> (atitem.Name))
> s.Logoff()
> s = None