Not able to send an email after creating the pivot table

activities
studio

#1

Hi All, in my requirement I need to send the pivot table excel sheet to an email, but getting the below error,

And below one is the xaml file attached.

Thanks,
Sushmitha.


#2

check if any other process is using the excel in Taskmanager and try once again


#3

@sushmithaelluru If u have opened that excel file, close it and run your workflow that will work for you.


#4

HI @Manjuts90, I wrote “excel.quit” in the vbscript of pivot table, the excel get closes, but also am getting the same mentioned error.


#5

@sushmithaelluru check once whether it is closing or not?


#6

Yes @Manjuts90, it is closing!! I attached the xaml file. Can you look into once.


#7

@sushmithaelluru

did you check any other excel processes are running in background in taskmanager process tab


#8

Yes @phyogananda, I checked . But no excel another process is running.


#9

we always face problems like these in our automation, if nothing works we will restart our system and execute. it will work always


#10

Ok, I will restart and check.


#11

@sushmithaelluru - Before sending the email could you save the file and send as an attachment in the mail activity.


#12

@phyogananda, after restarting the system too getting the same error!!


#13

@sushmithaelluru

you tried sending the mail without attachment, is it working ??


#14

Ya @phyogananda, tried but getting the below error,


#15

Without attachment, now am able to send email @phyogananda!!


#16

@sushmithaelluru

in that case, is any prob with excel like it is protected or locked.

can u try attaching some other file and see if u are getting same error.


#17

HI @phyogananda, there is no problem with the excel attached.!!


#18

@sushmithaelluru

try attaching some other excel file


#19

Ok, will try


#20

Hai @phyogananda, I attached the different excel sheet, getting the below attached error!