A project of taking email id from excel sheet of employees and send new email to them of their increment salary to them

Help Activities
, ,
1 
1. **Excel Setup:**
   - Create an Excel file (`EmployeeData.xlsx`) with `Sheet1` containing:
     - Column A: "Name"
     - Column B: "Email"
     - Column C: "New Salary"

2. **UiPath Workflow:**
   - Use `Excel Application Scope` → `Read Range` to store data in `dtEmployees`
   - Use `For Each Row in Data Table`
     - Get `row("Name").ToString`, `row("Email").ToString`, `row("New Salary").ToString`
     - Use `Send Outlook Mail Message`:
       - **To:** `row("Email").ToString`
       - **Subject:** `"Salary Increment Notification"`
       - **Body (HTML Enabled):**  
         ```html
         <p>Dear <b>{row("Name").ToString}</b>,</p>
         <p>We are pleased to inform you that your salary has been increased to <b>{row("New Salary").ToString}</b>.</p>
         <p>Congratulations and keep up the great work!</p>
         <p>Best Regards,<br>Your HR Team</p>
         ```
       - Enable `IsBodyHtml` = `True`

3. **Run the Automation:**
   - Execute the process to send personalized emails dynamically.

4. **Alternative for Gmail:**
   - Use `Send SMTP Mail Message`
   - Configure with:
     - **SMTP Server:** `smtp.gmail.com`
     - **Port:** `587`
     - **User:** Your Gmail
     - **Password:** App Password
     - **Same To, Subject, and Body as above**
   - Enable `IsBodyHtml` = `True`
2

Hello @Rohit_Kumar7 and welcome to the forum :slight_smile:

Where are you experiencing problems in the project?
You have written the formular for making it happen.

A thing to note is that Excel Application Scope activity is replaced by Excel Process Scope activity. If you still want to use Excel Application Scope you have to enable Classic activities by using the filter icon on the Activities pane.

A current version could look like this:

image
image472×725 20.7 KB

Regards
Soren

3

Hey @Rohit_Kumar7 so for this 1-use read range and save their output as say dt1
use 1 for each row activity and pass the dt1 in for each row inside the for each use send outlook or smtp in the
To- field pass the currentrow(“yourcolumnName”).tostring
and in the body write your message of increament of salary
so when you run it will take email id from excel one by one and send the salary increment message.
cheers