把Outlook信箱中的附件另存为

• 附件
• 信箱
• Set
• oMailItem
• As
• Dim
• Not

'Author: Lewis Cornick

'Date : 04/22/98

'http://www.geocities.com/SiliconValley/Haven/1768

'E-Mail:l_cornick@hotmail.com

'Description: To be used in 'stripping' attachments from

'e-mails in your inbox and save them to a hardcoded path.

'This bit of code will strip attachments and save them into the path

'"C:\temp\Outlook Attachments", it has no error handling so be warned!

'Code starts (placed under a command button.)

'这点代码将会找到Outlook信箱中的附件，并把它们保存至

'"C:\temp\Outlook Attachments"，它没有错误处理所以请小心使用！

'以下是代码（放在一个Command按钮下面）

Dim oApp As Outlook.Application

Dim oNameSpace As NameSpace

Dim oFolder As MAPIFolder

Dim oMailItem As Object

Dim sMessage As String

Set oApp = New Outlook.Application

Set oNameSpace = oApp.GetNamespace("MAPI")

Set oFolder = oNameSpace.GetDefaultFolder(olFolderInbox)

For Each oMailItem In oFolder.Items

With oMailItem

If oMailItem.Attachments.Count > 0 Then '?

oMailItem.Attachments.Item(1).SaveAsFile "C:\Temp\Outlook

Attachments\" & oMailItem.Attachments.Item(1).filename

MsgBox oMailItem.Attachments.Item(1).DisplayName & " was

saved as " & oMailItem.Attachments.Item(1).filename

End If

End With

Next oMailItem

Set oMailItem = Nothing

Set oFolder = Nothing

Set oNameSpace = Nothing

Set oApp = Nothing