Hello. I want to write a script which does the following.
1. Gets names of .csv files in a folder
2. For .csv files 1 to x in above, loop through the list and do the following
a. Extract email address from first line of the .csv file
b. Email the .csv file to the extracted email address.
I've came up with the following code, which does the above, but only for 1 and a bit iterations of the loop.
The output from the job log is below
So the first run through, it gets the first file name, extracts the email address and then sends the email. It then starts the second iteration through the loop. It gets the filename, but then seems to stop when its extracting the email address.
Any ideas of why this might be happening ?