I have a large amount of small emails that are automatically placed into a local folder. The information in these emails is of a standard nature with standard formatting in plane text and I was thinking of importing the data into OpenOffice.calc.

Because of the mbox format I can reliably macro edit out the header junk and any extraneous information

I run into 2 problems. I cannot readily identify where the local folders files are located.

I looked in /home/name/.evolution/mail/local/ however there are only directories that appear empty and some of the directories are old Local Folders in Evolution.

I have spent a lot of time trying to locate a specific mailing list for this question and if it cannot be answered
I would appreciate someone letting me know about it
Scott