Calendar Export

By Mark Harris

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…

Email Statistics

By Mark Harris

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…

Calendar Exchange!

By Mark Harris

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…

FTSE250 Fallers >5% Today

By Mark Harris
FTSE 250 stocks that have fallen more than 5% today. WordPress › Error

There has been a critical error on this website.

Learn more about troubleshooting WordPress.

StockValue (pence)Change Points% Change