Mail excel sheet

Help Studio
,
1

I want to mail excel sheet to mail id which is present in excel sheet how i do this can anyone tell me about this?

2

Hi @yogitagaikwad2206

Can you specify what you want to do.

Regards,

3

Hi @yogitagaikwad2206 ,

  • Excel Application Scope

    • Read Range (Excel file) - Output DataTable: dtEmails

  • For Each Row (ForEachRow activity) - Input: dtEmails

    • Assign - emailAddress = row(“Email”).ToString()

    • Send SMTP Mail Message

      • Properties:
        • To: emailAddress
        • Subject: “Your Subject Here”
        • Body: “Your email body content here”
        • Attachments: Add attachment if needed
        • SMTP Server, Port, Credentials: Set your SMTP server details

Thanks,
Vinit Mhatre

4

Hi @yogitagaikwad2206

  1. Use the read range activity to read the excel in which you have the mailid/ mailid’s
  2. Then use for each row in datatable activity to loop
  • then by using send smtp activity, send the path of the file in the attach file by passing the variable and path of the file
5

can u tell me how add attachment after clicking attachment how give file path

image
image1092Ă—552 30.8 KB

6

Create IN arguments: and add your desire file path in string

1 Like
7

image
image715Ă—212 7.63 KB

@yogitagaikwad2206

8

@yogitagaikwad2206

image
image980Ă—573 26.8 KB

Cheers!!

9

can u tell mi why this error come while reading excel file

image
image1476Ă—490 32.8 KB

image
image758Ă—498 19.6 KB

10

@yogitagaikwad2206 "

  • Open the XML file in a text editor or UiPath Studio.
  • Go to line 2, position 86, and examine the XML content around that location.
  • Look for any syntax errors, missing or incorrect attributes, or any other issues.
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.