Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL stored procedure and VFP
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00881693
Message ID:
00881723
Views:
30
Take a look at Re: Sending mail Thread #865220. It uses Win2K CDO + SMTP but you may try to adapt it.

>Sergey,
>
>Don't ask me why I want to do this....
>Basicly from SQL stored procedure I want to send an email by executing the following VFP program:
>
>oGroupWise=createobject('NovellGroupwareSession')
>oAccount = oGroupWise.Login
>oWorkfolder = oAccount.WorkFolder
>oMessages = oWorkfolder.MESSAGES
>oMessage = oMessages.ADD
>oMessage.FromText = "fname.lname@stago-us.com"
>oMessage.Subject = "Automatically generated email"
>oMessage.BodyText = "This is body text"
>oRecipients = oMessage.Recipients
>oRecipients.Add("fname.lname@stago-us.com")
>oRecipients.Resolve
>oMessage.SEND
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform