RogerH,
I think we are very very close. When I run this I get a Run-time error 3021 No Current Record, and it shows the error at
strEmailAdds = strEmailAdds & "; " & objMyTable.email
When I hover over strEmailAdds it shows all of the email addresses from my field with ; between them...