Here is my problem:

Our department had daily reports that we ran everyday and sent through
the email, now because the reports have grown over time with
enhancements and tracking more data they are too big to distribute
everyday so we moved to posting them on the company intranet. The
challenge faced now is that some of our employees travel often and dont
have access to the intranet therefore require the reports emailed to
them.

Is there anyway we could set up an email that is sent to a distribution
that includes a link that when the recepient clicks the link it will
trigger a reply email with the attachment, the files are always named
the same thing and are in the same directory.

Any ideas for a solution?

Thanks in advance for your help.