HEY Experts

[Former Member]

Please help with this query.

My query :- I want to send automatic email to those BP whose Invoice due date has come. If they have made the payment then message will not send.

Please help me.

Thanks

[lucjan_chmura · Accepted solution]

Hello,

assuming your question really is "How to send an automatic email using SQL Anywhere (version## ) ?" here is some links:

- to have things happened "automatically" you can use database events which will fire on schedule :

DocCommentXchange

- you can have a trigger on a table etc..

- have a look at this post for an example

http://scn.sap.com/community/sql-anywhere/blog/2010/01/15/using-sql-anywhere-innsbruck-to-send-email... showing how to send an email.

But, basically you need to get yourself familiar with SQL Anywhere system procedures related to mail:

xp_startsmtp - DocCommentXchange

xp_sendmai - DocCommentXchange

xp_stopsmtp - DocCommentXchange

Hope it helps.

Lucjan