I have an Access database with a table containing a list of email addresses of 220 members in an organization.
I would like to send a common notice to each email address in the Access table without having to enter each address into the Address book manually. Has anyone done this successfully?
I wrote a sub that trimmed the addresses, concatenated a semicolon and made a long string that I then pasted into an email To: box. This failed when the server found an address that wasn't valid. Instead of sending emails to those addresses that were correct and notifying of those that were not, the server quit and sent nothing.
I would like to send a common notice to each email address in the Access table without having to enter each address into the Address book manually. Has anyone done this successfully?
I wrote a sub that trimmed the addresses, concatenated a semicolon and made a long string that I then pasted into an email To: box. This failed when the server found an address that wasn't valid. Instead of sending emails to those addresses that were correct and notifying of those that were not, the server quit and sent nothing.