Friday, November 11, 2011

Sự kiện AttachmentAdd trong Outlook

Occurs when an attachment has been added to an item.
Kích hoạt khi một file được đính kèm
Sub object_AttachmentAdd(Attachment As Attachment)
object    An object that evaluates to one of the objects in the Applies To list. In Microsoft Visual Basic Scripting Edition (VBScript) in an Outlook form, use the wordItem.
Attachment Required. The Attachment that was added to the item.

Example

This Visual Basic for Applications (VBA) example checks the size of the item after an attachment has been added and displays a warning if the size exceeds 500,000 bytes. The sample code must be placed in a class module such as ThisOutlookSession, and the TestAttachAdd() procedure should be called before the event procedure can be called by Microsoft Outlook.
Public WithEvents newItem As Outlook.MailItem

Private Sub newItem_AttachmentAdd(ByVal newAttachment As Attachment)
 If newAttachment.Type = olByValue Then
  newItem.Save
  If newItem.Size > 500000 Then
   MsgBox "Warning: Item size is now " & newItem.Size & " bytes."
  End If
 End If
End Sub

Public Sub TestAttachAdd()
 Dim olApp As New Outlook.Application
 Dim atts As Outlook.Attachments
 Dim newAttachment As Outlook.Attachment

 Set newItem = olApp.CreateItem(olMailItem) 
 newItem.Subject = "Test attachment"
 Set atts = newItem.Attachments
 Set newAttachment = atts.Add("C:\Test.txt", olByValue)
End Sub

No comments:

Post a Comment