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
- Double click on Excel Operation Action Properties and change the file name, sheet and cell address
- Check cell variable (note variable #TOTAL_SALES# name)
- Select existing or create a new SMTP connection.
- Update email text (note #TOTAL_SALES# variable)
- 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 |