Send file to user

Help
21

@Palaniyappan

Could you perhaps make me a example? Because I really need it today.

Cheers, @Palaniyappan

1 Like
22

Fine change the scope of all variables in the variable panel to whole sequence
and change the type argument property as String in for each loop
and it gives output like ukjtenhoven.xlsx
but if we want only file name use GetFileNameWithoutExtension which gives us ukjtenhoven alone without .xlsx , instead of GetFileName,
that works
Cheers @ukjtenhoven

23

Thank you very much hero. I still have two questions if you don’t mind.

  1. So I need to change the GetFileName to GetFileNameWithoutExtension Because when I do this it gives me this error:

image

  1. And the robot also needs to send the user the file with their name. How could I accomplish this?

Thanl you already for all the help! @Palaniyappan

24

No worries

For this on the error is not because of left side value in the assign
change the right side variable type to string in the variable panel, its in the generic value type

Then for this

yes of course we can mention this filename either in Subject or in the body mail as well
in Subject property mention like this
"Text Email and the file name is " + out_filename.ToString
or in body in a similar way

Cheers @ukjtenhoven

1 Like
25

so did that work buddy
still any issue
Cheers @ukjtenhoven

26

Thank you very much the first one worked. But for the second one I mean like the file itself and not only the name:

image

Cheers, @Palaniyappan

27

Then we can use GetFilename
which would give the full name with extension, like this ukjtenhoven.xlsx
i thought you were in need of only name without extension
So that would work
Kindly try and let know for any queries buddy
Cheers @ukjtenhoven

28

Yes I think I explained it wrong.

The robot downloads report from a website. Then the robot renames the file to that persons name and then the robot should use the filename as the emailadress and is should also send the file itself. So the report.

Cheers, @Palaniyappan

29

So I only need that the robot Attach the file

1 Like
30

Fine, any issues still
Cheers @ukjtenhoven

31

Alright Thanks.

Yes the robot also needs to attach that persons file.

image

cheers, @Palaniyappan

1 Like
32

Fine
for that we got an option at the bottom the send mail activity named ATTACH FILE
For that we can mention like this
image
image
as item is the variable that holds the file path
Thats all buddy
its done
Cheers @ukjtenhoven

2 Likes
33

You sir are a hero thanks for the quick replys and help!!!

Kind Regards,

34

No worries
Keep going
Cheers buddy @ukjtenhoven

35

Hi @Palaniyappan,

Could you help me with another issue I have?

Cheers, @Palaniyappan

36

Fine
@ukjtenhoven

1 Like
37

I have the reports:

image

but there is a different one called: GridMessages.xlsx this one needs to be send to on specific email address. Would you have a idea of how I could accomplish that?

Cheers, @Palaniyappan

38

@Palaniyappan?

39

use a if condition within the for each loop and like this
item.ToString.Contains(“GridMessages”)
If it this gets satisfied it will go to THEN part were you can have a separate send mail activity or it will go to ELSE part where you can have your current send mail activity
Cheers @ukjtenhoven

1 Like
40

Yes thank you for everything

Cheers, @Palaniyappan