Excel_Email

[Anelisa_Bolosha]

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

[Anil_G (Anil Gorthi)]

@Anelisa_Bolosha

What activity are you using to send email

Cheers

[Anelisa_Bolosha]

Hi @Anil_G , I am using

[Anil_G (Anil Gorthi)]

@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

[Anelisa_Bolosha]

Where would I use the code?

[Anil_G (Anil Gorthi)]

@Anelisa_Bolosha

May I know if email is a variable?

And what is the value you are giving to it?

Cheers

[Anelisa_Bolosha]

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

[Anil_G (Anil Gorthi)]

@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

[Anelisa_Bolosha]

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

[Anil_G (Anil Gorthi)]

@Anelisa_Bolosha

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

Cheers

[Anelisa_Bolosha]

@Anil_G , it worked thank you so much

Cheers