Hello all.

I have request, but I'm not sure if Excel can provide a solution.

I have a number (+100) of documents on the server which are listed to one criteria (according to country).
I have an Excel document which lists these documents, but also with different criteria (theme, colour, continent, ...).

I have a search macro which will give me the documents I need (with one or more criteria), but now I would like these documents (pdf files) to be linked to server. In that way I can simply copy these selected documents (only from Europe e.g.) to add to an e-mail.

Is there a way to do this with Excel? If not, do you have any idea how to do this (a new program?)?

Thank you!

--------------------------------------
Example

Title Country Continent Colour Theme
--------------------------------------------------------------------
Doc A Australia Oceania Blue Sea
Doc B France Europe Red Sea
Doc C Germany Europe Green Mountains