Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Diana Watkins

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...