+ Reply to Thread
Results 1 to 2 of 2

Export Email Info to Access Database

  1. #1
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Export Email Info to Access Database

    Hi,
    I'm trying to build a database/work tool.

    Currently, one of the departments get all their work via e-mails and currently they are just using outlook + folders etc.

    What I would like is an outlook macro which exports all the emails which get received in the "inbox" folder to an access database.

    I would then like the macro to take all those emails that it has exported and move them to another folder called "exported".

    The information i would like exported to an access database is:
    To:
    CC:
    From:
    Received Date:
    Body Text:

    i guess also attachments but im not 100% sure if its necessary.

    Moving forward i would like to build forms n stuff in access so it looks more like a work tool etc but i guess this is the starting point.

    Also to keep in mind, this "inbox" folder is a shared mailbox, not the "inbox" of my personal email.

    I have to admit, i did find this http://blogs.techrepublic.com.com/howdoi/?p=119 but it doesnt show the recieved date and also the code for some reason doesnt work for me.

    Also, just so you know, i am using Outlook 2003 as my e-mail client
    hope someone can help me with this, cheers
    Last edited by pr4t3ek; 01-16-2009 at 08:11 AM.
    --
    Regards
    PD

    ----- Don't Forget -----

    1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks

    2. Thank those who have helped you by Clicking the scales above each post.

    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  2. #2
    Forum Administrator ExlGuru's Avatar
    Join Date
    03-17-2009
    Location
    India
    MS-Off Ver
    2003,2007
    Posts
    222

    Re: Export Email Info to Access Database

    Get some information to this link:
    http://blogs.techrepublic.com.com/howdoi/?p=119
    ExlGuru

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1