This is one of the draw back in data services, because we dont have in built feature for sending emails with attachments.
To solve this issue, We have to write a VB script
Step 1):- Open the notepad then Copy the below code and paste in notepad
strSMTPFrom = "prasad@gmail."
strSMTPTo = "prasad@gmail.com"
strSMTPRelay = "SMTPOUT.YOURCOMAPNY.COM"
strHTMLBody = " <HTML><BODY><font size=3>Hello Team,<BR><BR>HELLOOOOOOOOOOOOOOO. <BR><BR> Regards' <BR>Team</font></BODY>"
strSubject = "PFA"
strAttachment = "\\\\D:\\FILEPATH.CSV"
Set oMessage = CreateObject("CDO.Message")
oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strSMTPRelay
oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
oMessage.Configuration.Fields.Update
oMessage.Subject = strSubject
oMessage.From = strSMTPFrom
oMessage.To = strSMTPTo
oMessage.HTMLBody = strHTMLBody
oMessage.AddAttachment strAttachment
oMessage.Send
To solve this issue, We have to write a VB script
Step 1):- Open the notepad then Copy the below code and paste in notepad
strSMTPFrom = "prasad@gmail."
strSMTPTo = "prasad@gmail.com"
strSMTPRelay = "SMTPOUT.YOURCOMAPNY.COM"
strHTMLBody = " <HTML><BODY><font size=3>Hello Team,<BR><BR>HELLOOOOOOOOOOOOOOO. <BR><BR> Regards' <BR>Team</font></BODY>"
strSubject = "PFA"
strAttachment = "\\\\D:\\FILEPATH.CSV"
Set oMessage = CreateObject("CDO.Message")
oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strSMTPRelay
oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
oMessage.Configuration.Fields.Update
oMessage.Subject = strSubject
oMessage.From = strSMTPFrom
oMessage.To = strSMTPTo
oMessage.HTMLBody = strHTMLBody
oMessage.AddAttachment strAttachment
oMessage.Send
2) then save as filename.VBS
3) After that go to script and add the below command
$L_ORACLE= 'SELECT UPPER(sys_context(\'userenv\',\'instance_name\')) FROM DUAL';
$L_DATABASE = sql('DS_DATASERVICES',$L_ORACLE);
$G_V1 = cast(sql('DS_DATASERVICES','(select COUNT(1) FROM TABLE)'),'INT');
IF ($G_V1 >=1 and $L_DATABASE='DEV')
BEGIN
exec('CScript','\\\\FILEPATH\\FILE_DEV.vbs', 8);
END
ELSE IF ($G_V1>=1 and $L_DATABASE='QA')
BEGIN
exec('CScript','\\\\FILEPATH\\FILE_QA.vbs', 8);
END
ELSE IF ($G_V1>=1 and $L_DATABASE='PROD')
BEGIN
exec('CScript','\\\\FILEPATH\\FILE_PROD.vbs', 8);
END
ELSE
BEGIN
PRINT ('No Data found In DATABASE');
END
I really appreciate for your efforts to make things easy to understand. I was really many students struggling to understand certain concepts but you made it clear and help me bring back my confidence.
ReplyDeleteSAP bods Online training in hyderabad
SAP bods Online training in usa
SAP bods Online training certification
good blog,thanks you for sharing a information sap bods training in hyderabad
ReplyDeletesuch a nice blogsap bods course online training in Hyderabad,sap bods online training in usa,sap bods online training in canada,sap bods online training in australia
ReplyDeleteThe post is very unique it contains all the details of data service.
ReplyDeletenot able to find SMTP server name. How to find that?
ReplyDelete
ReplyDeleteThank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
SAP reseller
Software Reselling services
mbe supplier in software services
mbe software reseller services
bmc software vendors
MBE Oracle Reseller
Software reseller services in north america
sap minority reseller
Data recovery services
ReplyDeleteTwo Stones Is Top Web Design Company In Coimbatore India Crafting Static And CMS Websites In Html, Wordpress Website Design Coimbatore With User Experience To Generate Website Leads In Coimbatore
ReplyDelete[URL=https://twostones.co/web-design-company-in-coimbatore/]Website Design Coimbatore[/URL]
[URL=https://twostones.co/seo-company-in-coimbatore/]SEO Company In Coimbatore[/URL]
[URL=https://twostones.co/digital-marketing-company-in-coimbatore/]Digital Marketing Company In Coimbatore[/URL]
[URL=https://twostones.co/web-development-company-coimbatore/]Web Development Company In Coimbatore[/URL]
[URL=https://twostones.co/mobile-app-development-company-in-coimbatore/]Mobile Application Development In Coimbatore[/URL]
Two Stones Is Top Web Design Company In Coimbatore India Crafting Static And CMS Websites In Html, Wordpress Website Design Coimbatore With User Experience To Generate Website Leads In Coimbatore
ReplyDeleteWebsite Design Coimbatore
SEO Company In Coimbatore
Digital Marketing Company In Coimbatore
Web Development Company In Coimbatore
Mobile Application Development In Coimbatore
Online SAP FICO Training is Your Passport to Achievement in Career!
ReplyDeleteWe strive to ensure that the students are equipped with necessary knowledge to enter and succeed in the SAP marketplace.
ReplyDeleteWebsite design digital marketing company coimbatore provides digital marketing services in coimbatore ,digital marketing agency in coimbatore, social media marketing company in coimbatore,website design services in coimbatore, e-commerce website design , web application development,mobile application development in android and ios application in coimbatore, SEO services in coimbatore,graphic design , lead generation.
ReplyDeleteGraphic design companies in coimbatore
Website design company in coimbatore
Digital marketing company in coimbatore
ecommerce website development company in coimbatore
Web development company in Coimbatore
SEO company in Coimbatore
Mobile application development companies in Coimbatore
ReplyDeleteWonderful information! I admire the finished concept with the quality of the projects to be delivered. I agree that quality is the utmost priority in the tech world for clients. A month ago, I also persuaded the stage to hire a professional Javascript developer substituting my previous less-friend developers, which helped me enhance the quality of my projects. The credit goes to Eiliana.com, which lets me get the right experts to execute my approach.
Designed to equip professionals and students alike with the necessary skills to navigate the complexities of SAP's Financial Accounting and Controlling modules, Take the first step towards a rewarding career in finance with APTRON's ERP SAP FICO Training Course in Gurgaon.
ReplyDelete