Automate Microsoft Outlook From Vb Script Editor DebuggingTips and techniques from FMS for building better applications in Microsoft Access, Visual Basic 6, VB6, VBA, Outlook, SQL Server, Visual Studio. NET, Internet, Office. Last modified December 11, 2009. Ben Chinowsky, SDK Bridge. In this article Why Use VBA in Excel 2010 VBA Programming 101 Macros and the Visual Basic Editor. Short howto on using Outlook macros to move selected emails from Inbox to a target folder based on the GTD Getting Things Done system of processing input. How to use Outlook macros to move email from inbox to another folder. When my work PC came off lease I took the necessary steps to back up my documents, IE favorites, etc. I could add them on the new machine. Automate Microsoft Outlook From Vb Script Editor With Intellisense' title='Automate Microsoft Outlook From Vb Script Editor With Intellisense' />It happened. Bright, white light flashed before your eyes, the power of the sun licked your skin, and you felt a shock wave of dust and debris plow through the city. Interested in learning more about Excel VBA MrExcel will teach you how to use Microsoft Excel VBA. Check out our site for more information about Excel VBA tutorials. Its integration with Windows allows control of Internet Explorer in a number of surprising ways using Visual Basic for Applications VBA script from any application. After getting the new machine and turning in the old one, it didnt take me long to realize I had forgotten to copy something I use A LOT Outlook macros. Unfortunately, I didnt make notes when I set them up several years ago, so I had to start from scratch. There were plenty of examples on the web, but each assumed the target folder was located under the Inbox folder. My target folders were located on the same level as the Inbox. I finally got it working and decided to document the process for future reference. The premise behind these macros is based on David Allens Getting Things Done methodology GTD. I was also influenced by the Inbox Zero series on Merlin Manns 4. Folders website, and a very good 2. Mac. World article series entitled Empty Your Inbox. While my email inbox never really gets to zero, I am able to keep it pretty lean depending on how diligent I am in following the GTD system. Step 1 Create your target folders. To create folders, right click where you want to the folders to be created and select New Folder from the pop up menu. I created my folders under the main Mailbox home folder. If you want to have your folders sort to the top of the list, start the folder name with a symbol such as. Automate Microsoft Outlook From Vb Script Editor DownloadVisual Basic for Applications VBA is an implementation of Microsofts eventdriven programming language Visual Basic 6, which was discontinued in 2008, and its. PDF files that contain the Visual Studio 2005 documentation. I use 4 main folders Action Items I need to take action on to completeFiled Items I want to keep for future reference i. I dont want to delete itSomeday Items I may want to take action on at some point in the future no time constraintWaiting Items Im waiting on a response from someone else before I can resolve. Step 2 Create your Outlook Macros. In Outlook 2. 00. Tools Macro menu item and select Visual Basic Editor or use the AltF1. Copypaste the following VB Macro into the script editor. Make sure to change the name of the folders to match your email setting. Outlook VB Macro to move selected mail items to a target folder. Sub Move. To. Filed. On Error Resume Next. Dim ns As Outlook. Name. Space. Dim move. To. Folder As Outlook. MAPIFolder. Dim obj. Item As Outlook. Mail. Item. Set ns Application. Get. NamespaceMAPI. Define path to the target folder. Set move. To. Folder ns. FoldersMailbox Jim Merrell. FoldersFiled. If Application. Active. Explorer. Selection. Count 0 Then. Msg. Box No item selected. If move. To. Folder Is Nothing Then. Msg. Box Target folder not found, vb. OKOnly vb. Exclamation, Move Macro Error. For Each obj. Item In Application. Active. Explorer. Selection. If move. To. Folder. Default. Item. Type ol. Mail. Item Then. If obj. Item. Class ol. Mail Then. Item. To. Folder. Set obj. Item Nothing. Install Hackintosh On Core 2 Quad Q6600. Set move. To. Folder Nothing. Set ns Nothing. End Sub. Here is how it looks in the VB Editor Step 3 Test macros. To test the macros, click Run on the menu, the green play button, or press F5 Run Macro in the VB Editor window. If no errors are displayed, verify that the selected emails has moved to the desired target folder. Update 52. 52. 01. If nothing seems to happen when you run the macro i. See the following post for more information. Step 4 Repeat. Repeat steps 2 and 3 above to create a separate macro for each of your target folders. For simplicity, I added all the macros to the default module module. End Sub line of the previous macro. After you copypaste the code remember to Update the functionmethod name of the script to describe what the macro does i. Sub Move. To. Filed, Sub Moved. To. Action, etc. Update the path to your target folder. Save the macroscript file. Update 52. 52. 01. A cleaner way to avoid all the duplication of code the only difference is the name of the target folder is to have a main function that does all the work and then call that function passing in the name of the target folder. Example Outlook VB Macro to move selected mail items to a target folder. Sub Move. To. Foldertarget. Folder. On Error Resume Next. Dim ns As Outlook. Name. Space. Dim Move. To. Folder As Outlook. MAPIFolder. Dim obj. Item As Outlook. Mail. Item. Set ns Application. Get. NamespaceMAPI. Mailbox folder. Set Move. To. Folder ns. FoldersMailbox Jim Merrell. Folderstarget. Folder. If Application. Active. Explorer. Selection. Count 0 Then. Msg. Box No item selected. If Move. To. Folder Is Nothing Then. Msg. Box Target folder not found, vb. OKOnly vb. Exclamation, Move Macro Error. For Each obj. Item In Application. Active. Explorer. Selection. If Move. To. Folder. Default. Item. Type ol. Mail. Item Then. If obj. Item. Class ol. Mail Then. Item. Move. To. Folder. Set obj. Item Nothing. Set Move. To. Folder Nothing. Set ns Nothing. Sub Move. To. Filed. Move. To. Folder Filed. Sub Move. To. Action. Move. To. Folder Action. Sub Move. To. Waiting. Move. To. Folder Waiting. End Sub. Step 5 Add button to Outlook menu bar. To run the macro using the click of the mouse, or using hot keys, I added the macros to the menu bar. Right click on a toolbar and select Customize from the pop up menu. On the Commands tab of the Customize window, scroll down the Categories list and select Macros. You should see the macros created in step 2 above in the Commands section. To add a macro to the toolbar, left click and drag the macro commands to the toolbar and release in the desired location. With the Customize window still displayed, right click on the macro item in the toolbar to display additional customization options. To enable the macro to run using a keyboard shortcut, use the character before the desired character used in conjunction with the Alt key in the Name. For example, to run the Move. To. Filed macro with the Alt1 shortcut, change the name to 1. Move. To. Filed. Note the. Also, to save space on the toolbar, select Text Only Always. The finished result looks like this Now you can run your macro by clicking on the toolbar item, or using the Alt1, Alt2, or Alt3 shortcut. Next Adding Macros to Outlooks Quick Access Toolbar. Have a great dayDownload Visual Studio 2. Retired documentation from Official Microsoft Download Center. Generally, a download manager enables downloading of large files or multiples files in one session. Many web browsers, such as Internet Explorer 9, include a download manager. Stand alone download managers also are available, including the Microsoft Download Manager. You may not be able to download multiple files at the same time. In this case, you will have to download the files individually. You would have the opportunity to download individual files on the Thank you for downloading page after completing your download. Files larger than 1 GB may take much longer to download and might not download correctly. You might not be able to pause the active downloads or resume downloads that have failed. The Microsoft Download Manager solves these potential problems. It gives you the ability to download multiple files at one time and download large files quickly and reliably. It also allows you to suspend active downloads and resume downloads that have failed. Microsoft Download Manager is free and available for download now.