Hi Kenneth,
There's no built in way to do this in the OS, so you need some tools. Basically what you want is an SMTP client that can directly connect to a mail server and send email. Clients will have to specifiy a mail server (just like in Outlook etc).
There are some commercial tools available for this like wwIPStuff (plug for my company). To send email you do:
o=CREATE("wwIPStuff")
o.cMailServer="mail.yourserver.net"
o.cSenderEmail="
bbopp@test.com"
o.cSenderName="Bill Bopp"
o.cRecipient = [Rick Strahl
]
o.cSubject="wwIPStuff Test Message"
o.cMessage="Who said this had to be difficult?"
* o.cAttachment="d:\utl\hex.exe,d:\utl\kill.exe"
llResult = o.SendMail() && Send again - wait for completion
You can find more info at:
http://www.west-wind.com/wwipstuff.asp
Hope this help,
+++ Rick ---
>Hi,
> I am trying to workout some ways to enable emails to be sent directly from the database to all my clients.For example,I have statements of all my customers with each customer's statements on a different page.Upon viewing all the details,I have created a Send Button which enables those statements to be sent.I face a problem on how to separate all the different customers from that 1 statement and automatically send them out through email with just one click.Is there anyway this can be done.I would like to send the emails without having to go through the outlook interface.There will only be a status bar on display to show the progress.Thank you very much.
>
>Kenneth