This UiPath automation project streamlines the onboarding process by reading user data from an Excel file and sending personalized welcome emails automatically.
The bot identifies users who have not yet received an email, sends customized welcome messages, updates the status in Excel, and prevents duplicate email sending.
- Excel Automation
- DataTable Handling
- Conditional Logic
- SMTP Email Automation
- Process Automation using UiPath
- Reads user details from Excel
- Detects new users automatically
- Sends personalized welcome emails
- Tracks email status to avoid duplicates
- Updates status in Excel after successful email delivery
- UiPath Studio
- Excel Activities
- SMTP Mail Activities
- DataTable Operations
- VB Expressions
- Read user data from Excel
- Check email status
- Send welcome emails
- Update status in Excel
- Display completion message
Subject:
Welcome to USC Platform
Body:
Hi [User Name], Welcome to USC Platform!
| Name | Status | |
|---|---|---|
| John Doe | john@gmail.com | Sent |
| Alice | alice@gmail.com | Pending |
- Open the project in UiPath Studio
- Update the Excel file path
- Configure SMTP email settings
- Run the workflow
- Check updated status in Excel
- Employee onboarding
- Student registration systems
- Customer welcome emails
- Automated communication workflows
SUBHASMITA SENDH
Developed using UiPath for learning and automation purposes.