VBA Code could not sending automail to few people

[shiva_raj]

HI,


I wrote a code to send automail. Till 3 days before, it is worked fine. but today few auto mails are not sending.


Ex: in the 1st attachment, there are 8 names (in O Column), that means 8 mails need to send. But, Code sending mails to only 3 people (Akram, Andreyna, Gustavo ). I Can't understanding why vba code not sending mails remaining 5 people.

Note: 2nd attachment contains district managers (DM) list along with sample mail ids.

Early reply will be greatly appreciated.

Thank you in advance.


Regards
Shiva

 

[vletm]

shiva_raj
Have You tied to run that macro row-by-row and eg follow that i-value?
= do it even try to send to those five?
Do it give any err.number, while do run as I asked?