This Example Demonstrates how to read a single Excel cell value and email it

  • Download and install Advanced ETL Processor [Link]
  • Download and Unzip example [Link]
  • Create a new package and open .wfp file

 How to rename file using current date as part of file name

  • Double click on Excel Operation Action Properties and change the file name, sheet and cell address 

How to rename the file using the current date as part of file name

  •  Check cell variable (note variable #TOTAL_SALES#  name)

How to rename file using current date as part of file name

  •  Select existing or create a new SMTP connection.

How to rename file using current date as part of file name

  •  Update email text (note #TOTAL_SALES# variable)

How to rename file using current date as part of file name

  • Run the package by pressing the green arrow.

More Information

Please contact us if you need help with transforming the data

Visit ETL Tools Forum