Macro skips some of the emails when sent in large number (via VBA outlook)

[Shrikant]

Hi.

I have created a macro to which works as below

First part
one procedure refers a CSV file, create mails based on the row input & saves them in draft folder.

this is important because I want to review mails before sending them / i may decide not to send / send later....

Second part
other procedure goes through each mail in draft & send emails one by one. (it is a basic loop procedure with mailitem.send statement)

All the procedures work (I have tried upto 100 mails with no attachments)

but sometimes when number is large (say 200+ ) or mails have attachments, sending procedure skips some of the mails in draft. (i have no idea why this happens- please let me know if anyone knows)


I think I have to ask my procedure to wait till the current loop mail sent is complete..
Can someone guide me how to do that