Category: Outlook

Copy the code below into your Outlook VBA module (Alt+F11). Connect to a macro button on the ribbon if you use it regularly. ‘ ======================================================================= ‘ Routine to export selected calendar to a spreadsheet (Date, Subject, Location) ‘ ======================================================================= Public Sub ExportCurrentFolderToSpreadsheet() Set myOLApp = CreateObject(“Outlook.Application”) Set myOlExp = myOLApp.ActiveExplorer Set myOlSel = myOlExp.CurrentFolder Set…

Copy the code below into your Outlook VBA module (Alt+F11). Connect to a macro button on the ribbon if you use it regularly. ‘================================================================= ‘ Email Statistics ‘================================================================= ‘ Export inbox sender, received time, response type and response time to excel for analysis. Sub GetMailStats() Dim oMail As Object Set oFolder = Application.Session.GetDefaultFolder(olFolderInbox) Set fs…

New cappointments in your exchange server (corporate) calendar are automatically copied to your webmail calendar. This outlook macro looks for new appoints, creates a copy of the appointment in a folder on your PC and invites your webmail account to the new appointment. The new appointment retains the tile, timing and reminder, but removes the…

Several firms operate internet blocking software on some networks but do allow email which is scanned in either direction for inappropriate content. This VBA script can be incorporated into a permanently open Microsoft Outlook session on a network with internet access. When the account received an email it parses the title and replies with the…

There are several macros within this outlook toolbox, all source code is accessable for modification to suit your needs: Email Copy Unclassified Automatic Community of Practice Opener Email Statistics Download URL New Meeting Where Am I Export to Spreadsheet Requirements Windows 2000, XP, Vista or 7 Microsoft Outlook 2000, 2003, 2007 or 2010 Installation If…