Help with eml files

[ad]

Hi
My friend asked me to make a database for managing his business emails more efficiently. My thought is that he saves all emails into
eml files from OE. In MS Access we will automatically extract new email header information (eg. From, Subject, Date etc) from those
eml files into database together with the path of the eml files. So he can sort and search his emails easily, and open eml files if
he wants. That will address his another request - easily back up and restore emails.

Is there any existing code somewhere that I can use to extract information from eml files? or you may have a better idea to share.

Your help would be appreciated.

ad

 

[Arvin Meyer]

Not that I know of. But he can also save them as plain text files. If he
does that, he can parse the text out with VBA to separate records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hi
My friend asked me to make a database for managing his business emails

more efficiently. My thought is that he saves all emails into

eml files from OE. In MS Access we will automatically extract new email

header information (eg. From, Subject, Date etc) from those

eml files into database together with the path of the eml files. So he can

sort and search his emails easily, and open eml files if

he wants. That will address his another request - easily back up and restore emails.

Is there any existing code somewhere that I can use to extract information

from eml files? or you may have a better idea to share.