Although there is the functionality within Outlook where you can drag an email message and drop it on the calendar menu to automatically create an appointment – it copies many of the attributes of the email but it does not copy the mail sender & recipients to the appointment.
The following macro will allow you to do this:
I need to produce a weekly report detailing what work I have carried out. I diligently record this in my Outlook calendar. My weekly report needs to be submitted in Microsoft Excel.
The following macro will pull the entries for the last seven days from my calendar and store it in Excel format.
How often are you in Outlook and you receive an e-mail from someone and you want to know a little bit more about them. It may be as simple as looking up their phone number so that you can get back to them.
This lookup may be on your own intranet site or using LinkedIn, Facebook or Twiter.
The following Outlook macro will allow you to do this.
Quite often I want to create a task immediately off the back of sending an e-mail – usually to remind me to follow up with the recipient after a period of time. I created a macro to do this rather than having to remember to go into tasks and do this manually – better to keep the flow rather than having to remember the steps.
photo credit: Andrew Coulter Enright
If like me your Outlook calendar can get a bit hectic and others can add meetings to your calendar sometimes you end up simply “reacting” to your schedule and jumping from one appointment to the next on “autopilot”. It’s at times like these that Outlook’s ability to create a reminder can save your dignity.
However, sometimes the meeting organiser does not set a reminder. I have created an Outlook macro that will look for incoming meeting requests, without a reminder set and give you the option to set a reminder.
One of my main productivity “sinks” is continually monitoring Outlook to see if any mails have arrived.
I have a rule set up that notifies me if an “important” email lands but for this to run, outlook needs to be running (minimised of course). I can’t resist the temptation to just “have a peek” outside my first thing in the morning, last thing at night email window.
To get around this I want to be “discouraged” from opening Outlook.
To implement this I have used Antonio Franca’s fantastic WinTrigger AutoHotkey script.
photo credit: laffy4k
If you look at the left hand menu you will see the items:
These can be quickly accessed by using the following shortcut keys:
- (Ctrl+1) – Mail
- (Ctrl+2) – Calendar
- (Ctrl+3) – Contacts
- (Ctrl+4) – Tasks
In addition, when you use Ctrl+1 to access mail, this takes you to the folder that you were last using, if you would rather jump straight into your In-Box – use (Ctrl+Shift+I).
A nice quick hint.
I kept forgetting to start Google Calendar Sync when I started Outlook. I don’t always start Outlook when I start my laptop and I’m not always online when I run Outlook so puting it in my Startup folder is not really an option.
My solution, a macro that runs when Outlook starts that gives me the option of running Google Calendar Sync if I feel it’s appropriate.
Private Sub Application_Startup()
Dim response As Integer
response = MsgBox(prompt:=”Do you want to run Google Calendar Sync?”, buttons:=vbYesNo)
If response = vbYes Then
RetVal = Shell(“C:\Program Files\Google\Google Calendar Sync\GoogleCalendarSync.exe”, vbMinimizedNoFocus)
NOTE: WordPress seems to “prettyfy” the quotes so when copying the code above it is better to delete and retype the quotation marks in your code editor of choice.
I’m using Microsoft Outlook 2007 and I think it’s a great piece of software.
It has a built in RSS feed reader. Typically I use Google Reader but as that can’t handle authenticated feeds I’m using Outlook for all of my work related Sharepoint feeds.
In order to introduce people to RSS, Microsoft have included two “standard” RSS feeds: “Microsoft At Home” and “Microsoft At Work”.
The only problem is, I’m not really interested in reading these feeds.