Afvikling af script til sletning ved anvendelse af imap-server
Hej ExperterJeg har længe irreteret mig over den måde outlook håndterer imap-mapper..Mange spørgsmål herinde går på at outlook sætter to streger over en email når når man ønsker at slette den, i stedet for at overfører den til én imappe fx trash.
Jeg har søgt på nettet og fundet følgende script:
Sub DeleteMessages()
Set myOlApp = CreateObject("Outlook.Application")
Dim myNameSpace As NameSpace
Set myNameSpace = myOlApp.GetNamespace("MAPI")
Dim myExplorer As Explorer
Set myExplorer = myOlApp.ActiveExplorer
'Get the folder type, expected type is 0 i.e. mail folder. If other type of folder
'being used then abort macro as it should only be used with mail folders.
folderType = myExplorer.CurrentFolder.DefaultItemType
'Check that folder is mail folder
If TypeName(myExplorer) = "Nothing" Or folderType <> 0 Then
GoTo invalidMailbox
End If
'Locate root folder for this account
Set thisFolder = myExplorer.CurrentFolder
Do Until thisFolder.Parent = myNameSpace
Set thisFolder = thisFolder.Parent
Loop
Set accountFolder = thisFolder
'Identify selected messages
Dim selectedItems As Selection
Set selectedItems = myExplorer.Selection
Dim currentMailItem As MailItem
Dim iterator As Long
'Run loop on selected messages
For iterator = 1 To selectedItems.Count
Set currentMailItem = selectedItems.Item(iterator)
'Move messages to Deleted Items folder
Set trashFolder = accountFolder.Folders("Deleted Items")
currentMailItem.Move (trashFolder)
Next
'Now, purge deleted messages
Dim myBar As CommandBar
Set myBar = Application.ActiveExplorer.CommandBars("Menu Bar")
Dim myButtonPopup As CommandBarPopup
Set myButtonPopup = myBar.Controls("Edit")
Dim myButton As CommandBarButton
Set myButton = myButtonPopup.Controls("Purge Deleted Messages")
myButton.Execute
Exit Sub
invalidMailbox:
MsgBox ("Macro configured only to work with mail folders! ")
Exit Sub
End Sub
Jeg vil høre om nogle af jer kan få det til at virke, da jeg har lidt problemer med det.
