Thanks again for these guys.

After lots of testing against the data that i have (around 19,000 rows) it turned out that the best way to do it was using...

Hey guys,

Thanks to you both for replying and helping with the solution to this. They both work PERFECTLY :-D:-D

This is MASIVELY appreciated. Thank you SO much.

Matt

Hi Paul,

Thanks for the response.

what i am hoping for is to update the alternate email culumn with all of the email addresses that we have listed for that...