Nadya,

>
> I agree with Borislav...
>

I also had the idea of flipping the "ON"-Statement but it did not appear to me as a solution as it's working in most cases. Last night, after I wrote the question, about ten mails were created and sent out flawlessly.

I can display (uses the same function) EVERY mail that comes in via the COM-Server. Only the COM-Server sometimes does not "see" the body-record when sending the mails. And when he does not see the record, he does not on the next run, which is five minutes later.


> ...and also avoid using single letters like a and b, put ml for
> MAILS and mb for MAIL_BODY or use these names as they are.

Hmmmm.... I would never do

use MAIL alias A in 0
use MAIL_BODY alias B in 0
do something

but I never had an issue about using single letter LOCAL aliases (that is within a SQL-Statement) in about ten Years FoxPro. Do You have more info on that (link to a document or so)?

>
> ... Also is your ID a character field?
>

Yes, it's Char(10) and fully filled or not existing. PK on MAILS. Looks something like this "T000010527"

I'll try Boris' and Your hints but I'm afraid it's something different.