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…

Textual Analysis

By Mark Harris

Upload a text file to find the number of times each sentence appears in it File path: This tool searches the text in the uploaded file for sentences. Then counts the number of times each unique sentence appears. The results are presented in a table for copying into your document. Invalid file. Must be txt…

Broadband Speed Test

By Mark Harris
Downloaded 20 kbytes in 0.0002 seconds
Downloaded 20 kbytes in 0.0002 seconds
Downloaded 20 kbytes in 0.0002 seconds
Downloaded 20 kbytes in 0.0002 seconds

Hence your download speed is 100 Mbps

Track Previous Groupon Deals

By Mark Harris

Have you ever missed a groupon deal and wish you could find out when it came back. This page allows you to set search keywords to check against daily deals across the country. You will be emailed a link to the groupon page if a match is found. Keywords

Acronym Finder (without Lookup)

By Mark Harris

This tool searches the text in the uploaded file for acronyms. Sorts the list and removes duplicate entries. Then looks for the definition in your original document e.g. Three Letter Acronym (TLA). The results are presented in a table for copying into your document. Upload a text file to find all the acronyms in it…