Correctly configure and use SQL mail_PHP tutorial

After a lot of effort some time ago, I finally figured out the configuration and use of SQL mail.
_Rambo asked me to compile relevant documents and share them with everyone.
I will describe my process of configuring SQL mail.
I use SQL mail mainly to complete the following functions:
> After the user registers online, the system will send a randomly generated password to the user’s registered email
> The user has a reply to the forum post When the content is sent to the user's Email
, because the above process is completed in the storage process, it avoids the
transmission processing of parameters by the front-end program, and there is no need to use third-party components to complete it, which feels more convenient.
1. In order to use SQL mail, you must first have an SMTP service on your server. I did not install the SMTP that comes with the win2000 server. Instead, I used the SMTP of imail6.04, which feels more stable and has stronger functions.
2. Install a mail system. I installed outLook 2000. I found that when configuring the mail profile, if
does not install outLook but uses other third-party programs, the win2k Chinese server version can be found in the control panel. There is no "Mail" item.
3. After installing Outlook, refresh the control panel and you will find the "Mail" item. Double-click to configure the mail and give the configuration file a name (assumed to be myProfile) so that For future use of SQL mail, set various properties in this configuration file.
4. Start Outlook (set to use myProfile as the default profile), test sending and receiving emails, and confirm that Outlook is working properly.
5. Start SQL server with the current domain account. In the support service of Enterprise Manager, click on the properties of SQL mail. You can see that in the configuration file selection, the myProfile configuration file just defined appears (you can also Define multiple profiles), select this profile for testing, and SQL will return information about successfully starting and ending a MAPI session. If an error occurs or the email profile is not found, there must be something wrong with the account you used to start the SQL server
6. Now you can use the extended stored procedure >[,][@message =] 'message']
[,][@query =] 'query']
[,][@attachments =] attachments]
[,][@copy_recipients =] 'copy_recipients [;...n]'
[,][@blind_copy_recipients =] 'blind_copy_recipients [;...n]'
[,][@subject =] 'subject']
[,[@type =] 'type']
[,][@attach_results =] 'attach_value']
[,][@no_output =] 'output_value']
[,][@ no_header =] 'header_value']
[,][@width =] width]
[,][@separator =] 'separator']
[,][@echo_error =] 'echo_value']
[,][@set_user =] 'user']

http://www.bkjia.com/PHPjc/631154.html

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631154.htmlTechArticleAfter a lot of effort some time ago, I finally figured out the configuration and use of SQL mail. _Rambo asked me to compile relevant documents and share them with everyone. Let me describe the process of configuring SQL mail...