Thanks for your reply and code Graham


I am familiar with VBA in Excel , but have never used it in Outlook

I need to know where to copy the code to i.e do I create an email template or can I set this up in Excel and then run the macro from there?