Outlook Macro for moving specific mails and reading their content

I have just finished off developing this macro. It is my first project which I uploaded SourceForge. In order to download code, follow this link: https://sourceforge.net/projects/outlookmacro/

What does this macro do?

  • Find the mails which have the specific subject in Inbox folder (In this case, subject is “New resume has been received!”)
  • Creating a mail folder named like Resumes 8/26/2012 1:29:50 PM under Inbox.

    The folder that created by macro
  • Moving those mails to Inbox > Resumes 8/26/2012 1:29:50 PM
  • Creating a local folder named like Resumes 8/26/2012 1:29:50 PM under C: drive
  • Saving those mails’ attachments under C:\Resumes 8/26/2012 1:29:50 PM

    Attachments are saved under C: drive
  • Reading content of those mails and creating Excel file

Notes:
– A reference named “Microsoft Excel 14.0 Object Library” must be added
– It searchs mails under only Inbox folder

Leave a Reply