Send Email with PDF Output

First and foremost check is to see that the JDE.ini has been setup with settings to mail with the SMTP settings in it, and that your SMTP allows the service.
JDE.ini – [JDEMAIL] settings needs to be configured as
1Rule1=90|OPT|MAILSERVER=SMTPSRVRNMATL20

To check your SMTP services status use Telnet (needs Admin priv)
Open Telnet Host Name = SMTP Servername Port = smtp Termtype = what ever it defaults
It will give you SMTP Server status

To know more about JDE.INI visit – http://www.scribd.com/doc/2088833/JDE-ini

Step 1 -
Create new Driver UBE which will then call the UBE who’s output has to be E-Mailed.
Step 2 -
After the above is done. We need to get the JobNumber of the executed UBE, to retrieve the PDF from the ExecutionHost server. So we need to use the PATH to the Server Print queue and the output file name.
The Usual PDF Output naming format is: R551234_VERSION_JOBNUMBER_PDF (If output in UNIX servers) else use .PDF
Please visit the link to see how to retrieve the Server JobNumber
Step 3 -
Once the full PATH is generated use BF B0500190 (SendEMailHRM) to use the file as attachment and send to respective person(s).

Shown below is a sample code of what the parameters are.

VA rpt_MessageText = "Message text" VA rpt_Subject = "Subject Text"

//GET THE JOBNUMBER for the UBE using above said Logic //Lets say Retrieved rpt_ServerJobNumber // VA rpt_AttachFileName = concat("PATH",concat(rtrim(ReportName,' '),concat("_",concat(rtrim(VersionName,' '),concat("_",concat(rtrim([VA rpt_ServerJobNumber],' '),"_PDF")))))) VA rpt_AttachDesc = concat(rtrim(ReportName," "),concat("_",concat(rtrim(versionname," "),".PDF" ) ) ) // RV FileName = VA rpt_AttachFileName // If VA rpt_ServerJobNumber is greater than // Send E-Mail - HRM

“JDE_System@jdedwards.com” -> szFrom
VA rpt_All_To_ID -> szTo
VA rpt_All_CC_ID -> szCC
VA rpt_Subject -> szSubject
VA rpt_MessageText -> szMessageTextChar256
“1″ -> cIncludeAttachmentFlag01
VA rpt_AttachFileName -> szNameOfAttachmentFile
VA rpt_AttachDesc -> szAttachmentDisplayText
UNDEFINED -> cSendCopyOfEMailToSelfFlag01
UNDEFINED -> cSetOneWorldErrorFlag01
UNDEFINED -> cRecordOperInLogFileFlag01
UNDEFINED -> cAppenOrOverwriteLogFile01
UNDEFINED -> szNameOfLogFile
RV Variable 000006 <- mnErrorCodeReturned

End If

The Problem with the above BSFN is that the attachment file path can not be greater than 40 Chars. So we may need to copy the BSFN to replace the DD Item with something of atleast 256 chars in length.

You may love to read the following document for more information – JDE-Email-Settings