Firstly :
\nI want to execute the SP and get the resultset in the attachement for mail.
\nSP name : Exec rpt_XC_BUF_SUM
\nDB : fi4_xc_prod
\nServer : FACETSRPT\\FACETS<\/p>\n
I want to capture the resultset of above SP into the txt file to be attached in mail.<\/p>\n
Secondly : I want to run the below query and capture the result set (that is count) into the Body of the mail.
\nDB : fi4_xc_prod
\nServer : FACETSRPT\\FACETS
\nQuery : select count(*) from fi4_xc_prod.dbo.XC_BUF where TBL_ORDER_ID=’C’<\/p>\n
The body of the mail shoulde be like :
\nListing of today’s claim batch ID’s and count is attached. Total Count: (From above query).<\/p>\n
The below is the mail script i have :<\/p>\n
SMTPServer = “mail.xxx.com”
\nRecipient = “suhail_abbas@xxx.com”
\nCc = “suhail_abbas@xxx.com”
\nFrom = “suhail_abbas@xxx.com”
\nSubject = “Test email”
\nMessage = “Listing of today’s claim batch ID’s and count is attached. Total Count: (From above query)”
\n‘attachment = Here the attachment from the above SP result set. It should be text file<\/p>\n
GenericSendmail SMTPserver, From, Recipient, Subject, Message<\/p>\n
Sub GenericSendmail (SMTPserver, From, Recipient, Subject, Message)<\/p>\n
set msg = WScript.CreateObject(“CDO.Message”)
\nmsg.From = From
\nmsg.To = Recipient
\nmsg.Cc = Cc
\nmsg.Subject = Subject
\nmsg.TextBody = Message
\n‘msg.AddAttachment attachment
\nmsg.Configuration.Fields (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserver”) = SMTPServer
\nmsg.Configuration.Fields(“http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusing”) = 2
\nmsg.Configuration.Fields.Update
\nmsg.Send
\nEnd Sub<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[55],"question_tags":[],"class_list":["post-13532","question","type-question","status-publish","hentry","question-category-programming"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/13532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=13532"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=13532"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=13532"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=13532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}