Shulou(Shulou.com)05/31 Report--

How to use SQL Mail to send and receive and automatically deal with extended storage in email, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

First, start SQL Mail

Xp_startmail @ user,@password

@ user and @ password are both optional

You can also open Support Services in Enterprise Manager, right-click on SQL Mail to open the right-click menu, and then press Start to start

2. Stop SQL Mail

Xp_stopmail

You can also use the Stop in the menu in the above method to stop

3. Send mail

Xp_sendmail {[@ recipients =] 'recipients [;... n]'}

[, [@ 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 >

[, [@ dbuse =] 'database >

Where @ recipients is required

Parameter description:

Parameter description

@ recipients recipients, separated by commas

@ message messages to be sent

@ query determines a valid query to execute and attach to the message, which can reference any object except the insert and delete tables in the trigger

@ attachments attachment

@ copy_recipients CC

@ blind_copy_recipients BCC

@ subject title

@ attach_results specifies that the query result is sent as an attachment

@ no_header does not send the column name of the query result

@ set_user query join user name. Default is Guset.

@ dbuse the database used for the query. Default is the default database.

Read the mail in the mail inbox

Xp_readmail [[@ msg_id =] 'message_number > [, [@ type =]' type' [OUTPUT]]

[, [@ peek =] 'peek >

[, [@ suppress_attach =] 'suppress_attach >

[, [@ originator =] 'sender' OUTPUT]

[, [@ subject =] 'subject' OUTPUT]

[, [@ message =] 'message' OUTPUT]

[, [@ recipients =] 'recipients [;... n]' OUTPUT]

[, [@ cc_list =] 'copy_recipients [;... n]' OUTPUT]

[, [@ bcc_list =] 'blind_copy_recipients [;... n]' OUTPUT]

[, [@ date_received =] 'date' OUTPUT]

[, [@ unread =] 'unread_value' OUTPUT]

[, [@ attachments =] 'attachments [;... n]' OUTPUT])

[, [@ skip_bytes =] bytes_to_skip OUTPUT]

[, [@ msg_length =] length_in_bytes OUTPUT]

[, [@ originator_address =] 'sender_address' OUTPUT]]

Parameter description:

Parameter description

@ originator Sender

@ subject theme

@ message Information

@ recipients recipient

The number of bytes skipped when @ skip_tytes reads mail information, which is used to get message segments sequentially.

@ msg_length determines the length of all messages, usually dealing with long messages together with @ skip_bytes

5. Process the next mail sequentially

Xp_findnextmsg [[@ msg_id =] 'message_number' [OUTPUT]]

[, [@ type =] type]

[, [@ unread_only =] 'unread_value >)

VI. Delete mail

Xp_deletemail {'message_number'}

Delete all messages in your inbox if you do not specify a message number

7. Automatically handle mail

Sp_processmail [[@ subject =] 'subject >

[, [@ filetype =] 'filetype >

[, [@ separator =] 'separator >

[, [@ set_user =] 'user >

[, [@ dbuse =] 'dbname >

This is the answer to the question about how to use SQL Mail to send and receive and automatically deal with extended storage in email. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.