![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#10
|
|||
|
|||
![]()
I made all the changes Michel, thanks a lot.
Actually I think the slow speed is in part because of the way I invoke the macro. I select on item then invoke the macro by pressing my macro button, then I repeat for the next item, etc. A better method would be to select multiple items first and then invoke the macro once to move the multiple selected items at once. For completeness, here is my final code: Sub MoveToTrash() On Error Resume Next Dim objNS As NameSpace Dim objFolder As MAPIFolder Dim objItem As MailItem Dim Sel As Outlook.Selection ' "Trash" folder in user namespace Set objNS = Application.GetNamespace("MAPI") Set objFolder = objNS.Folders("KJB").Folders("Trash") ' Warn if "Trash" folder doesnt exist If objFolder Is Nothing Then MsgBox "This folder doesn't exist!", vbOKOnly + vbExclamation, "INVALID FOLDER" End If ' User selected emails to move to trash Set Sel = Application.ActiveExplorer.Selection ' For each mail item in user selection, move it to "Trash" folder For Each objItem In Sel objItem.UnRead = False objItem.Move objFolder Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Eliminate need for "Enable Macro" selection | cte67 | Outlook and VBA | 7 | August 21st 09 07:30 PM |
eliminate error message "Borlane Database Engine not installed" | Outlook 2007 needs help - | Outlook - Installation | 2 | June 5th 08 06:47 PM |
How do I edit "show time as" drop down selection? | DGarton | Outlook - Calandaring | 1 | November 29th 07 11:56 PM |
find/eliminate "active content" in a customized outlook form | TomS | Outlook - Using Forms | 1 | August 3rd 07 04:54 PM |
how to delete email address from "to" button selection | Buckskin | Outlook - Using Contacts | 2 | June 12th 07 12:56 AM |