kmugglet has asked for the wisdom of the Perl Monks concerning the following question:

Newbie question,does anyone know of a site or guru that can show me how to automagically extract CSV attachments from email either from the mbox or by downloading direct from my IMAP4/POP3 account.
The attachments arrive daily with the same name, so I need to save them as they arrive and then put the contents into a database (more questions to follow probably :-)
Thanks in advance for any help given
Keith

Replies are listed 'Best First'.
Re: Extracting Email Attachments
by BazB (Priest) on Feb 27, 2002 at 19:12 UTC

    Dunno so much about the automagical part of the question - you need to put some effort into coding a few things first :-)

    Look at CPAN, particularly modules like Net::POP3 or Mail::IMAPClient to download messages from a server or Mail::Box to access mailboxes, Mail::Internet to grok the messages, MIME::Parser to handle attachments and the relevant DBI module to stuff everything into a database.

    Cheers.

    BazB.