Niton, thank you I'll give this a go.
Would I be taking the micky if I asked if this code could be converted to VBA code suitable for Excel?

I just copied and pasted it and Excel did not like it.

I'll try outlook, see if that will play ball.

cheers
smiler44