Excel_Email

Hi guys,

I have this excel file in which I write all the emails that I need to send to, when I put A single email address it does send but then I want to add more than one email address in the list that the bot can send to. How do I separate them, I tried using semicolon as in the attachment but does not work

@Anelisa_Bolosha

What activity are you using to send email

Cheers

Hi @Anil_G , I am using
image

@Anelisa_Bolosha

Just to be sure can you use a trim in the code…

like in_Config("Email").ToString.Trim

Semi colon should work but if there are spaces it would fail

cheers

1 Like

Where would I use the code?
image

@Anelisa_Bolosha

May I know if email is a variable?

And what is the value you are giving to it?

Cheers

Okay this is how I have declared it, yes it’s a variable:
image

image

@Anelisa_Bolosha

After .ToString add a .Trim

But I believe this might be a different email…because in excel it is Email and not email

Xheers

1 Like

Sorry this was to just make an example in the original excel that I am using it’s ‘email’

@Anelisa_Bolosha

Then please add .Trim there and check…better print the value to check once before send email usinn log message

Cheers

2 Likes

@Anil_G , it worked thank you so much

Cheers

1 Like

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