Sending Email from SQL Anywhere Database

[former_member1335322]

I am trying to send the results of a query in an email. I need to use two functions to do this. First, I need to call the xp_startsmtp function, and then I can use the xp_sendemail function and specify whom I would like to send the email to.

The xp_startsmtp function requires two parameters, but I do not know what information I should put.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbreference/xp...

[chris_keating]

The arguments seem to be self explanatory, The first argument is valid email address for the SMTP mail server. The second argument is the SMTP server. For example, sending mail via the email account user user@mail.com would call something like:

call xp_startsmtp( 'user@mail.com', 'smtp.mail.com' )

(Prior post used gmail SMTP but this no longer works reporting SMTP code 6.)

[former_member1335322]

Thank you Chris. You have answered both of my questions, and I appreciate it