email files to correct person

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
timle
Pro Scripter
Posts: 96
Joined: Tue Apr 20, 2004 5:53 am

email files to correct person

Post by timle » Thu Dec 22, 2016 2:28 pm

Hello,
I was wondering if someone could point me to an example of the script that check if file with name "john.pdf" in a folder then look up in an excel sheet or text delimited file for john's email and send the John.pdf to john's email.

Thank you

Digging thru the older post, I was able to come up with something that works

User avatar
CyberCitizen
Automation Wizard
Posts: 721
Joined: Sun Jun 20, 2004 7:06 am
Location: Adelaide, South Australia

Re: email files to correct person

Post by CyberCitizen » Mon Dec 26, 2016 1:11 am

There wouldn't be an example script for it, but could be done.

You would need to make sure that there are only one John for example or have the file name match if there are more than one John.

Example John Smith.pdf, John Jones.pdf

As long as the file names are matched the same as the excel file it should be fairly easy.

If they aren't you might need to use some regex. That I am not very good at.

Hopefully that helps.
FIREFIGHTER

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts