studiox
2020.10
false
- Release Notes
- Getting Started
- Tutorials
- Automation Projects
- Creating Automations
- Automation Basics
- Automation Best Practices
- Tutorial: Creating a Pivot Table
- Tutorial: Iterating Through Rows in a Table
- Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
- Tutorial: Extracting Data From Automated Emails and Moving It to a Desktop Application
- Tutorial: Filtering Data in Excel
- Tutorial: Formatting Cells
- Tutorial: Adding Information About the Files in a Folder to an Excel File
- Tutorial: Adding Your Own Formulas to the Project Notebook
- Tutorial: Copying From CSV to Excel and Emailing the File
- PowerPoint Automation
- Common Activities
Tutorial: Copying From CSV to Excel and Emailing the File
OUT OF SUPPORT
StudioX User Guide
Last updated Dec 20, 2023
Tutorial: Copying From CSV to Excel and Emailing the File
In this tutorial, we'll copy the data from a CSV file to an existing Excel file and then we'll attach the Excel file to an email and send the email from Outlook.
We will create a project and start by adding a Use Excel File activity to indicate the Excel file where we want to copy the data. Inside this activity, we will add a Read CSV activity to indicate the CSV file to copy from and where in the Excel file to copy to. We'll then add a Use Desktop Outlook App activity to indicate the Outlook account to use and inside it we will add a Send Email activity to send the email.