Loading text from a file to send in body of HTML email

This is in context to www.etl-tools.com/forum/advanced-etl-pro...multiples-files.html

Now I have multiple xls or csv file containing orders of a salesman . 

Is it possible to send items in body of an email instead of attachment

Dear XYZ,
Please see the orders you made

Order ID,Salesman Name,Customer Name,Product Name,Quantity,Unit Price,Order Date,Delivery Date
001,Prashant,John's Boutique,Men's Leather Oxford Shoes,150,2000,2024-04-17,2024-05-17
002,Prashant,Elite Footwear,Ladies' Casual Sneakers,200,1500,2024-04-17,2024-05-17
003,Prashant,The Shoe Stop,Men's Running Shoes,120,1800,2024-04-17,2024-05-17
004,Prashant,Fashion Feet,Women's High Heels,85,2200,2024-04-17,2024-05-17

Cheers,
PM 


 

Please have a look at the following article

www.etl-tools.com/wiki/knowledgebase/tip...-email-message-text/

Can I use loop to read location of multiple files from a csv and then pass to email package?

Yes you can

Hellos,
I am now trying to load the file whose location is saved in a CSV , 

I am using LOOP action to iterate through files and send the file location 



My script , how do I pass the variable for #file# ? I know I have to use  {GetVariable('#file#')}, but for life of me , dont' know next steps



begin

This should work