I am attempting to generate an email using EDAMAIL that list...

[Diana Watkins]

I am attempting to generate an email using EDAMAIL that lists information associated with potential rehire employees. The email will list the employees code, name, reason for termination, term code, etc. What I am also attempting to capture are the safety entries (entry type and comments) for the employee - for which there can be several. Whenever I bring those records in, however, it will only list the first entry type/comment (-WRITE MAILDEF &PRTYPE &PRDESC). Im looking for a way to list all of the entries and am having trouble figuring out how.

JOIN

LEFT_OUTER DRCODE IN DRVANSWER TO MULTIPLE PRDRCD IN SYPR AS J2

END

TABLE FILE DRVANSWER

PRINT

DRCODE

DRNAME

DRTERM

DTREASDES

DTREHIRE

COMMENT1

COMMENT2

COMMENT3

PRTYPE

PRDESC

ON TABLE HOLD AS HOLD1 FORMAT ALPHA

END

-RUN

-READFILE HOLD1

-IF &LINES EQ 0 GOTO NO_HOLD1;

-RUN

-GOTO HOLD1

-NO_HOLD1

-SET &EMAIL=;

-HOLD1

-SET &&TMPPATHDEF=TEMPPATH (100,A100);

-SET &MAIL_FILE=&&TMPPATHDEF || maildef.txt;

FILEDEF MAILDEF DISK &MAIL_FILE

-RUN

-WRITE MAILDEF EMAIL CHANGE FORM

-WRITE MAILDEF

-WRITE MAILDEF Driver Code: &DRCODE

-WRITE MAILDEF Name: &DRNAME

-WRITE MAILDEF

-WRITE MAILDEF Term Code: &DRTERM

-WRITE MAILDEF Reason: &DTREASDES

-WRITE MAILDEF

-WRITE MAILDEF Rehire Eligible: &DTREHIRE

-WRITE MAILDEF

-WRITE MAILDEF Question 1: Why did you leave Maverick

-WRITE MAILDEF Answer: &COMMENT1

-WRITE MAILDEF

-WRITE MAILDEF Question 2: What other jobs did you have after Maverick

-WRITE MAILDEF Answer: &COMMENT2

-WRITE MAILDEF

-WRITE MAILDEF Question 3: Why do you want to return to Maverick

-WRITE MAILDEF Answer: &COMMENT3

-WRITE MAILDEF

-WRITE MAILDEF Performance

-WRITE MAILDEF Entry Type: Comments:

-WRITE MAILDEF &PRTYPE &PRDESC

-WRITE MAILDEF

-RUN

-MRNOEDIT EX EDAMAIL dwatkins@maverickusa.com,Driver Rehire Consideration &DRCODE,TXT,MAILDEF

-RUN

-*-HTMLFORM IBFS:/WebFocus/EDA/EDASERVE/APPPATH/mav_prod_recruit/rehire_ss_lookup.htm

-INCLUDE IBFS:/WFC/Repository/Rehires/Home/Rehire_SSN_Lookup.fex

-EXIT

[Diana Watkins]

Apologies, I am on v.8202

[Martin Yergeau]

Just a thought : why not creating a report that will then be sent by mail

[Diana Watkins]

Well I guess I could do that, I am certainly open to other options. Currently, they are manually looking up all of the pieces of information about the employee and typing it up in an email with screenshots, then sending it to an executive rehire committee. I was trying to duplicate that email as best as I could and capture all of the data in the body of the email. When the user looks the employee up by SSN, they would have the ability to answer a few questions regarding the rehire and click a button that automatically gathers the info and sends the email.

Also fairly new to WebFocus and not familiar with sending a report by mail aside from creating a schedule in RC.

[Martin Yergeau]

Take a look at page 125 on how to use EDAMAIL with an HTML file as a message attachment

Developing Reporting Applications Release 8207 (informationbuilders.com)

[Diana Watkins]

OK, I did get that to work - is there a way to maybe combine both. For instance, have the term info on the body of the email, and an attachment with the safety records

[Martin Yergeau]

According to the doc it seems not because what you need to provide to include as attachment has to be left blank to include as inline message body

Refer to doc

[Diana Watkins]

I got this to work the way I needed it to. I dumped the data out to an Excel spreadsheet with a separate tab for the safety records. Thanks so much!