Multiple Email attacmemts depending on the input

[Saravanan13]

Hello all,

I am looking to send emails with attachment details as shown below. There should be only email send for each CUST ids. The Email attachment  example is also shown below.

The number of attachments for each account should be dynamic. Because we are not sure about maximum limits of attachments for each account.

Can anyone help me configure the Email tool according to my requirement. I tried using summarize tool to group cust ID and concatenate filename and then separated as columns and added each column in email tool but getting error since some of the columns will be null depending on the number of attachment.

Filename	cust ID
\\Desktop\file\Input\John	123456
\\Desktop\file\Input\Mark	44444
\\Desktop\file\Input\David	123456
\\Desktop\file\Input\Peter	55555
\\Desktop\file\Input\Ali	123456
\\Desktop\file\Input\Saina	123456

Expected Email result

CustID	Email attachments
123456	Attach John,David,Ali,Saina documents saved in the fokdler
44444	Attach Mark documents saved in the fokdler
55555	Attach Peter documents saved in the fokdler

[Saravanan13]

Can anyone assist on this.

[flying008]

Hi, @Saravanan13 

Maybe you need make a macro for email tool to modify the  attachment option.

[Saravanan13]

Can you assist on creating Macro please

[binuacs]

@Saravanan13 macro attached, you need to supply the email address field also in the input file then that email should be configured in the email tool

[flying008]

Hi, @binuacs 

What is the Role of basic Table tool in your macro ? 

[binuacs]

@flying008 I simply used the table tool if the user want to display some thing on the body of the email, it is not needed to send the attachments 

[flying008]

Hi, @binuacs 

oh, I see, thank you for your reply.