I wrote this football pool program which autoemails everyone in the pool sheets for them to put their picks on. They then email it back (saving the file as unique name so the program can automatically pick it up). The problem is:
a) The person in charge of the pool has to take each email (from 30 ppl) and store the attached sheet in a special location.
b) People keep changing the file name, which means that the main program, when compiling the picks into a master document, "doesnt find it".

I thought about adding an 'email back' button on each personal picks sheet, but then they have to toy with enabling macros and setting security levels (which i dont want to do for them)

Any thoughts for a better solution? Thanks!