One form in a project of mine sends a customized email message out immediately upon hitting the "Send" button, while updating a table.

I have been asked by my manager to add a function to that form that will allow him to search for and select any file to attach to that email. The file could be in any number of places on the network or his hard drive, and he envisions it just like adding attachments directly in Outlook.

Adding an attachment is no problem, but previously, I've only had to identify the file in one directory, and could code the attachment. Now I have to find a file that could be anywhere.

I'm sure there's a way to do this, but I haven't dealt with it before, and don't know where to start. Any suggestions?

Patrick