apps.skype.com'SUB per verificare la presenza della parola ALLEG e ATTACH nel messaggio
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
'per il codice che cerca ALLEG
Dim answer As Variant
'per il codice che cerca ATTACH
Dim lngPos As Long
Dim strText As String
Dim strSearchText As String
Dim lngStringCount As Long
lngPos = 1
lngStringCount = 0
'Facciamo prima cercare gli allegati
If InStr(1, Item.Body, "alleg", vbTextCompare) > 0 Then
If Item.Attachments.count = 0 Then
answer = MsgBox("E' stato rilevata la parola Allegato ma non è presente nessun allegato, inviare comunque?", vbYesNo)
If answer = vbNo Then
Cancel = True
End If
End If
'Se non ci sono allegati, cerchiamo gli attachments
Else
Do
lngPos = InStr(lngPos, Item.Body, "attach")
If lngPos > 0 Then
lngStringCount = lngStringCount + 1
lngPos = lngPos + Len("alleg")
End If
Loop Until lngPos = 0
'MsgBox lngStringCount & " occorrenze"
' >3 perchè nella firma compare 3 volte quindi devo ignorare le prime 3 volte
If lngStringCount > 3 Then
answer = MsgBox("E' stato rilevata la parola Attachment ma non è presente nessun allegato, inviare comunque?", vbYesNo)
If answer = vbNo Then
Cancel = True
End If
End If
End If
End Sub'Macro per salvare i messaggi in formato MSG con l'export del timestamp INIZIO
'http://www.slipstick.com/developer/code-samples/save-selected-message-file/
Public Sub SaveMessageAsMsg()
Dim oMail As Outlook.MailItem
Dim objItem As Object
Dim sPath As String
Dim dtDate As Date
Dim sName As String
Dim sSender As String
Dim enviro As String
enviro = CStr(Environ("USERPROFILE"))
For Each objItem In ActiveExplorer.Selection
Set oMail = objItem
sName = oMail.Subject
sSender = oMail.SenderName
ReplaceCharsForFileName sName, "_"
ReplaceCharsForSenderName sSender, "_"
dtDate = oMail.ReceivedTime
sName = Format(dtDate, "yyyymmdd", vbUseSystemDayOfWeek, _
vbUseSystem) & Format(dtDate, "_hhnn", _
vbUseSystemDayOfWeek, vbUseSystem) & "_" & sSender & "_" & sName & ".msg"
sPath = enviro & "\Documents\"
Debug.Print sPath & sName
oMail.SaveAs sPath & sName, olMSG
Next
End Sub
Private Sub ReplaceCharsForFileName(sName As String, _
sChr As String _
)
sName = Replace(sName, "/", sChr)
sName = Replace(sName, "\", sChr)
sName = Replace(sName, ":", sChr)
sName = Replace(sName, "?", sChr)
sName = Replace(sName, Chr(34), sChr)
sName = Replace(sName, "<", sChr)
sName = Replace(sName, ">", sChr)
sName = Replace(sName, "|", sChr)
End Sub
Private Sub ReplaceCharsForSenderName(sSender As String, _
sChr2 As String _
)
sSender = Replace(sSender, " ", sChr2)
End Sub
'Macro per salvare i messaggi in formato MSG con l'export del timestamp FINE


Page created in 0.032 seconds with 9 queries.