I have some VBA code that is executed from Access that loops through a recordset and builds about 400 email messages. With each iteration of the loop, some parameters are passed to a function that creates an Outlook object to send the message. If I run this code and allow Outlook to display the message and send each one manually, it works fine. But if I include the "send" command in the code, I get the message that "Outlook does not recognize one or more names".
I believe this is occurring because VBA is attempting to send the email before the Exchange server has had time to resolve the email address to a contact. I am not using names, but actually using the full email address. I tried turning off "Automatic Name Checking" and "Suggest names while compleing To,Cc, and Bcc fields" in Outlook, but this had no effect. Any ideas?