I was under the impression that the code at
http://www.sweetpotatosoftware.com/SPSBlog/ for CDOSYS
was all self contained and all that was required to send email.
Is that not true?


Andy


>>Have you ever used CDOSYS ?
>>I am running into a problem when it gets to .send()
>>Error 1429
>>The server response was not available.
>>
>>Any thoughts?
>>
>>
>>Andy
>>
>>>>In V6 is there a way to set up a trigger to send an email out
>>>>when a record is added to a table with the data that is
>>>>in that record?
>>>>
>>>>If not any suggestions how to handle that?
>>>>
>>>>thanks
>>>>Andy
>>>
>>>Andy,
>>>Check Graig's BLOG, how to send an eMail from VFP.
>>>http://www.sweetpotatosoftware.com/SPSBlog/
>
>Andy,
>
>Whatever method to send mail you use, you must be prepared for it to fail
>
>I think a trigger should never fail because a mail cannot be sent
>
>One way to implement is as follows
>
>Make a class MailQueue and instantiate it at the beginning of your application or when needed (max one instance running)
>
>A trigger may queue a mail, ie pass the data to the queue by calling a method, and return fast. Under no circumstance may it fail, ie if the object does not exist or the queue command fails, the trigger must still return TRUE
>
>The MailQueue has a timer that is fired every so often (eg 60 seconds or more).
>When it fires it tries to send a mail from the Queue. If a send of a single mail fails, you retry (in the next timer cycle) up to max say 3 times. After that, discard the mail from the queue
>
>If the sending of a mail is successful, continue sending until the queue is empty
>
>When the MailQueue object destroys, it tries to send all the mail (once) that remains in the queue, and then destroys.
>
>
>
>The MailQueue runs in its own datasession. Thus it can keep a table of the mails, and temp files (attachments)