Originally Posted by toughiv

This is great. Now mail merging is a lot simpler! Thanks.

There is one slight prob i have now - when the macro transposes - the value of the date columns then becomes numerical. Is there a way I can retain the format of dd/mm/yyyy?