Send email from Access2002 to multiple recipients using Outlook

[PurpleUnicorn]

I have a table with email addresses and filenames. Many addresses receive the same file.(20 to be exact). I am sending the emails using the Outlook object.
I have created a string with all of the addresses separated by "; " but I get the error "outlook does not recognize one or more names". When I send individual emails, there is no problem with the names/addresses. Is there some way to accomplish this?

Thanks!

 

[GoodOmens]

In your code do you have a resolveall?

Dim mlItem as Object 'mail message
...
mlItem.Recipients.ResolveAll
mlItem.Send

 

[PurpleUnicorn]

Thanks for the response. What does ResolveAll do?

I was able to solve the problem - there was a bad email address in the client data. As soon as I removed the record, everything worked fine.