Can spotlight show where files are?

Lost some emails during a system change-over. They don't appear in my Mail viewer but I can find some of them using Spotlight by remembering certain words and phrases. But Spotlight doesn't tell me where the files are that it's found. Presumably other files are located there as well. At least if I knew where they were I could open them with a text editor or something.