This content has been marked as final. Show 5 replies
Problem is probably due to this line
strFromAddress = DW.Security.fUserEmailGet(DW.Connection.PstrUserID)
not actually retrieving an email address. Have you set up an email in FDM user maintenance for the user you are running the script under? Hard code an email here and I imagine the script will work or simply fill in an email for the users in user maintenance
Ok, that worked. Once I entered the admin's e-mail address in user maintenance the e-mail genereated. Thanks for your help.
However, the only thing that shows up in the body of the e-mail is "This is the status of the current load", which is what I typed in on the "strEmailMsgLine" line. So my question is, what should show up in the e-mail? How do I get this to show some valuable infomation? Does the script need to be added to a load action or event script?
That is a bit of an arbitary question. It all depends on where in the context of workflow you are and what information you are hoping to send to the user. If you find answers helpful in the forum please mark as such. Also I wouldn't advise marking a post as anwered if you post a follow up question.
Sorry for the confusion. I am just trying to get an understanding of how others may be using the e-mail capability.
So to be more specific, we are using the batch loader to load the current month and prior month Actuals daily. In the batch loader script, we are able to write a batch loader report to the file system that details the status of the data loads. Ideally I would like to put this report in the body of the email that is generated.
I think now that I have the e-mail working I can play around with the script to see if I can get exactly what I want.
You could simply attach the generated report to the email. There should be a .Attachment property of the send mail object, just point that to the report file.