BEGIN DECLARE content LONG VARCHAR; set content='select * from shipper'; CALL xp_startsmtp( smtp_sender = 'mfkpie8@163.com', smtp_server='smtp.163.com', smtp_port='25', timeout=240, smtp_auth_username='mfkpie8', smtp_auth_password='password'); CALL xp_sendmail( recipient='131t@qq.com', subject='ssssssss',"message"=content,query='select * from shipper'); call xp_stopmail(); end question: But did not receive my email, just received ‘select * from shipper',Don't have any data asked 21 Nov '13, 04:42 mfkpie8 |
This is expected behaviour - confine the docs on the query parameter:
So I guess you will have to either
The cited doc page shows some samples on the usage. answered 21 Nov '13, 05:06 Volker Barth Can you help me to modify under my SQL
(21 Nov '13, 05:24)
mfkpie8
|
Try This: CALL xp_sendmail( recipient='Sales Group', subject='New Pricing', include_file = 'C:\DOCS\PRICES.DOC' ); answered 21 Nov '13, 05:17 Adiel |