E-mail Notification - Report in the Body of the mail

[DSFreddie]

Hi All,

I am creating a statistics report after the ETL cycle run & I am currently attaching this report through the email notification & sending it to stakeholders.

Is there a way I can send the content of the report in the e-mail body itself?

I browsed through the forum for an answer & couldnt find any solution to it.

Any thoughts are appreciated
Freddie

[chulett]

It's been discussed a number of times here. To get it in the body you need to "roll your own" routine to send mail with a variable body. You could start with DSSendMail and tweak it, or start from scratch.

[josh.guffey]

DSFreddie here is an example of server routine that will take a variable for the body:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

   FullArg = ""

   If ToAddress <> "" Then
      FullArg<-1> = "To:":ToAddress
   End
   If FromAddress <> "" Then
      FullArg<-1> = "From:":FromAddress
   End
   If Subject <> "" Then
      FullArg<-1> = "Subject:":Subject
   End
   If SMTPServer <> "" Then
      FullArg<-1> = "Server:":SMTPServer
   End
   If Attachments <> "" Then
      FullArg<-1> = "Attach:":Attachments
   End
   If MessageBody <> "" Then
      FullArg<-1> = "Body:":MessageBody
   End

   Code = DSSendMail(FullArg)
   
   Ans = Code

Here are the descriptions for the Arguments:

Code: Select all

ToAddress - Who to send mail to, e.g. you@there.com
FromAddress - Who the mail is from, e.g. me@here.com
Subject - Subject line
SMTPServer - Name of server to contact for sending mail
Attachments - Pathname of file to send as attachment - multiple paths may be given separated by commas
MessageBody - One or more lines of text, separated by \n if multi-line