The macro you create will vary, depending on the e-mail program you are using.
However, your knowledge of VBA leaves much to be desired.
Most people like me and you are not real Microsoft Office gurus.
So, we may not know all specificities of calling this or that option, and we cannot tell the difference between VBA execution speed in Excel 20.
I created my folders under the main Mailbox home folder. Count = 0 Then Msg Box ("No item selected") Exit Sub End If If move To Folder Is Nothing Then Msg Box "Target folder not found! If no errors are displayed, verify that the selected email(s) has moved to the desired target folder. ", vb OKOnly vb Exclamation, "Move Macro Error" End If For Each obj Item In Application. You should see the macros (created in step 2 above) in the Commands section.
If you want to have your folders sort to the top of the list, start the folder name with a symbol such as ‘@’. ", vb OKOnly vb Exclamation, "Move Macro Error" End If For Each obj Item In Application. Update 5/25/2011: If nothing seems to happen when you run the macro (i.e., no error message and the email isn’t moving to the target folder), the security settings on the machine may be blocking the macros from running. Step 4 – Repeat Repeat steps 2 and 3 above to create a separate macro for each of your target folders. To add a macro to the toolbar, left-click and drag the macro command(s) to the toolbar and release in the desired location.
Once it is e-mailed, you can delete the workbook from your system, as your worksheet is still in the original workbook, as well.