Read excel name column value match with excel sheet name and send email as attachment and give the result successful or failed for each

Help Activities
, , , , , , , , , , , , , ,
1

Individual Target Sheet.xlsx (69.5 KB)

Hi All i am trying to build a bot i am still learning it will be a great help for me
i want to build bot to Read excel name column value to match with excel sheet name and send email that one sheet as attachment and give the result successful or failed for each

2

@toufikmujawar

  1. First use a use excel file and give the excel path
  2. Use for each row in excel with Excel.Sheet("sheetname")
  3. Inside loop use read rangw with Excel.Sheet(currentrow.ByField("Emp Name").StringValue) and assign it to dt
  4. Use a write range workbook and write the dt to the newexcel as you need
  5. Send outlook mail message activity with attachment as the file created and mail id as currenrow.ByField("Mail").StringValue

You can use a try catch if you see that the sheet might not exists or can check first if sheet exists or not before read range

Cheers

3

can you give example

4

@toufikmujawar

I have given whole of the process itselft above

Please try the same

Cheers

5

Hi Anil
thanks for the help process is working nice
but i want to attaché the excel sheet for that particular name sheet now i run this its attaching the hole excel file

6

@toufikmujawar

You need to use a write range and write only required sheet to a separate excel and then attach that new excel instead of the original one

Cheers

7

image
image698×425 14.3 KB

ITS NOT WORKING

8

@toufikmujawar

In attach what did you attach

Cheers

9

Team Target Mail sender.zip (107.2 KB)
here is my hole work flow
when i run the bot he is sending others file as well i want ex: Name A attach A sheet for B name B sheet pls help me

10

Any update on this
i am not able to resolve this

11

@toufikmujawar

Please check this

image
image992×652 23.5 KB

Team Target Mail sender.zip (107.4 KB)

cheers

12

Thank You So000000 much

1 Like
13

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