Hi, I have an automatic job that generates an excel file and includes the attachment into each email address found in the query. From this task, I want to eliminate the task of sending the attachment and send the **data directly into the body of the email. **
Sample of data:
Week_Ending RegHrs Missing Over_Booked Email
02-27-11 30 10 M@
03-06-11 32 8 M@…
03-13-11 55 15 M@…
03-06-11 41 8 1 P@…
I tried the email derivation but I do not know how to group the records before sending the email. I do not want to send data by rows.
If there is more than one row in the file for the same email address, I want to get all the data related to that user and send only one email with all the correlated rows and columns.
I am using TDA ver2.7
Thanks in advance for any help to this task.