What activity to use if I need to attach a specific PDF based on an excel data range?

Help StudioX
,
1

What activity should I be using if I wish to include a flow where the bot picks up a specific pdf in a folder, based on a excel list.

For example, Based on data range on Excel List
Customer A needs to be sent INV01

Bot picks up INV01 from folder and attaches it.

I have 200 customers each with their own invoice number, based on the excel range which will list which file name should be the correct invoice the bot needs to pick up.

Is this possible in StudioX?

2

Hello,

Something like this should work rather well. All the building blocks are there, you just have to customize them with your specific file paths and conditions.

image
image1199×1344 31 KB