Thanks once again Jaslake. I managed to get it working myself, not quite as efficiently as your code tho, so I think I will use yours

Is it possible to send the email without the user having to press send in the email client?. It opens up outlook then seems to change to MS word to send the email, although I think it could be something to do with how I have my MS Office set up.

One last thing, will this work ok in the 2003 version of excel? The people who will be using this only have that version.