I'm programming in asp.net c#. Our website sends batch emails.
I have run into a problem where I have sent a batch of emails (about 200) and roughly half were sent and half were not.
This also happened again where I sent 17 emails and only 10 were sent.
Basically a SQL call gets the rows and then loops through each one and sends each email using asp email component.
The company which I use to send the emails said they never received the request from our website to send the emails which didn't get sent.
So I want a way to allow me to know if an email was not sent. I have thought about the following. Whats the best way to do this?
My ideal is to get access to their email logs of emails that we send and then i can loop through and update our database saying that they were received. The current company wont allow this. Does anyone know of someone who could help?
I could create a logging table in sql when i send emails to the external smtp company but how do i actually know that they were received?
Any ideas would be appreciated.