Send emails with attachment name condition

[newdev1]

Hi Everybody,

I have around a 100 files which need to be emailed regularly to different people in different entities of my company.

The condition is that the first 3 characters of a file denote the entity code.

I have to draft the email by attaching all files with the same entity code and send them to the controllers of that entity.

Is there a way to automate sending the emails by reading the first 3 characters of a file name and clubbing them together.

I am new to PA and English is not my first language hence apologies in case of any mistake. 

Please do ask me for any clarifications needed.

Thanks in advance

[NickyTemperley]

Unfortunately I don't think this is possible, I don't think you can dynamically add multiple attachments to an email.

The only alternative I can think of is sending one atachment per email, but thats probably not a feasible with 100ish documents.

You could write an email per entity code, then just send the relevant email depending on which code was selected using a switch statement, but that may not be feasible either depending on the numbers.

Sorry, probably not the answer you were hoping for.