Anything that does not realy sit anywhere else.
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 have gotten into a nice grove of writing a blog post a day – mostly describing some script, macro or hack that I have implemented. Today I have (rather belatedly) discovered RescueTime which will log and report on your online activities.
This has ironically distracted me from thinking about my blog whilst I install it on my phone and my chromebook. In return, I’ll investigate the API over the weekend and write up anything interesting that I find.
Let me know in the comments if you have any cool hint’s, tips or sample code that you would like to share with me.
Sounds too good to be true – usually a warning sign – in this case it IS true. I have been using Quidco since 2006 and am almost at Entrepreneur level (have earned £500 cash back).
The basic premise is, you shop online as normal except you visit Quidco first, this sets up an affiliate link and the cashback comes to you rather than the advertiser. In return Quidco keeps the first £5 of the cashback so if you don’t use it it doesn’t cost you anything.
To try and push me across into the next level I’m offering a referral bonus, if you click on the image below, join and have earned £5 cashback this link will give you an additional £5!
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.
I have all of my contacts loaded into Google Contacts but the problem is, I’m never convinced that they are up to date or even sure if I should still have the person’s contact details listed.
To address this I created the following script which will send me an email every day with a randomly selected contact.
I can then review the contact’s details, compare it with LinkedIn, Facebook and Twitter and then either update their contact details or send them an e-mail to catch up with them.
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.
I’m sure I saw this ages ago but just rediscovered it today (working from home).
Basic premise is – various curators from various cities create a playlist in various genres.
Not found a duff track yet !
There are often scenarios such as rolling backups or rolling logfiles where I create folders which have the date in the folder name.
HINT: Using the format YYYYMMDD means that an alphabetic search is also chronological!
In most cases I only want to keep a certain number of these folders and delete the older ones. The following script will implement this deletion process.
For any dos batch files that I run on a regular basis I commonly want to create a folder or a text file with the current date in the file name. I’m a purist and I like my dates formatted as YYYYMMDD so that an alphabetic sort is also chronological.
The following script will place the current date into a variable in the required format.
One of the main reasons that I use Microsoft Excel is to keep lists to share with multiple people. Microsoft Word has great versioning and colabarative editing capabilities, Excel not so much. The main problem I have is knowing when a particular row has been changed and who changed it.
The following macro implements this.