Excel automation using UiPath

Help Activities
, ,
1

image
This is my config file and how i add multiple email id to BCC i have try with , but it dosen’t work

2

Hi @yogitagaikwad2206 ,

Use semicolon as separator instead of comma.

A;b;c

1 Like
3

Hi @yogitagaikwad2206 ,

Try using Semicolon ; instead and check.

1 Like
4

Hi @yogitagaikwad2206

Try to use Semicolon ; as a separator (and no space between the different addresses is fine).
What could also help: Right-click and remove the “Link” from the cells.

Best regards
Roman

1 Like
5

using semicolon its not work

6

Can you perhaps share the error you are getting? @yogitagaikwad2206

7

no error is occured

image
is this correct to convert string to array for config

Name | value

VCC       |    ABC@gmail.com;XYZ@gmail.com;PQR@gmail.com
8

@yogitagaikwad2206

The issue is in conversion…

Please use VCc.Split(";")

cheers

9

Hi @yogitagaikwad2206

I don’t think you’re supposed to use an Array at all?
Simply retrieve your Value from the Config and store it/use it in a String-Variable and effectively in the “BCC” properties of the “Send Mail” Activity you are using.

Therefore, Semicolon should work as a delimiter. No spaces between the different recipients. Store it as String-Variable. I recommend removing the Links in your Excel (Config) with Right-Click - Remove Link, there’s no need to store it as a hyperlink in your file and it can cause unnecessary issues.

Hope this works and helps!

Best regards
Roman

10

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