THANK YOU SO MUCH

I am now having a funny issue

If i send a test email to a different email address on my domain (i.e. i put myemail@mydomain.com in column J) the emails come through fine from my returns@mydomain.com email so the code works.

however any other external email addresses in column J (i.e. my gmail email) i get the following error:

Run-time error ‘-2147220977 (8004020f)’:
The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Relaying not allowed! Bad sender IP address

I sense this is less of a code issue but something else - any ideas?