Sending email through store procedure

Database email setup

  • Double click ‘Databse Mail’ to start setup

e1

Create mail configuration

  • select as below

e2

  • key in the profile name and click ‘Add’

e3

  • key in email address and the server ip address

e4

  • add the SMTP email address and server ip address

e5

  • click ‘Next’

e6

  • click ‘Finish’

e7

 

Store Procedure

Parse in the profile to be use to send email, recipient email, email body message and email subject.

e8

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s