Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Getting email addresses from Outlook Inbox (Access 2003 SP2)

    Is there a way in Access to populate a table with email addresses from the Outlook Inbox.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Getting email addresses from Outlook Inbox (Access 2003 SP2)

    Let's say you have a table tblAddresses with a text field Email. There should be a unique index on the Email field to prevent duplicate entries. You can use the code from the attached text file to read the e-mail addresses of the senders of the messages in the Outlook inbox into the table.

    Notes:
    - The code uses DAO, so you need a reference to the Microsoft DAO 3.6 Object Library.
    - You'll get security warnings. See <post#=317048>post 317048</post#> for some ways to deal with this. The free utility ClickYes is the simplest to use.
    Attached Files Attached Files

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Getting email addresses from Outlook Inbox (Access 2003 SP2)

    Thanks Hans, i will try this a bit later, i need to go to the doctors first.

Posting Permissions

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