When I do massive use of a campaign, I have sometimes the problem that some e-mails are not sent.
There is not user report that enables you to get them, so I have gone through phpMyAdmin to find and analyze them. The table used are:
1.- e-mail messages not sent:
SELECT * FROM `emailmessage` WHERE `sentdatetime` is null
2.- Select specific campaign items:
I have removed the emailmessages without sentdatetime and its respective campaignitem.
Campaigns status values
- Active = 2
- Processing = 3
- Completed = 4