MICROSOFT OUTLOOK: Saving olOLE's

[sclary34]

Does anyone know how to save olOLE's attachments out to a directory?

 

[ide]

i save the all message contain like this as html

 

[sclary34]

What I'm trying to do is programatically remove attachments from Outlook messages. When someone copies and pastes part of a spreadsheet for example, Outlook treats that as an attachment and its called an olOLE. I haven't found any methods that will save these attachments out to a directory.

 

[jonscott8]

where oMail represents the mail item in question:

For Each oAttach In oMail.Attachments
If oAttach.Type = olOLE Then 'olOLE = 6
oAttach.SaveAs "C:\temp\" & oAttach.FileName
End If
Next Jon Hawkins

 

[sclary34]

Jon,

When I run that code it gives me the Run-Time error 'Outlook cannot do this action on this type of attachment.'

Thanks,

Scott