Results 1 to 2 of 2
  1. #1
    SamanthaSteClaire is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    1

    Linking Access and Outlook


    Stunningly, I can find very little on this subject. I have a database of clients that I want to link with Outlook emails. Is there a way to connect my database to outlook (presumably through the unique email address) so that when I am in my database, I can scroll or click through all of that particular client's saved emails??? If this isn't possible, someone needs to create it and make a mint!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    This thread shows code to search Outlook folder for a subject and returning the sender address. Maybe adaptable to your needs. http://www.mrexcel.com/forum/showthread.php?t=52159
    Instead of writing to rows of spreadsheet, write to a list box.


    According to this http://www.outlookcode.com/article.aspx?id=25 you can link to Outlook folders and then query like a table.
    Without programming, you can add a table linked to an Outlook or Exchange folder to any Access database, using drivers built into Office 2000 (or later), by following these steps:
    1. In Access, click the New Table button to add a new table.
    2. In the New Table dialog, choose Link Table, then click OK.
    3. In the Link dialog, under Files of type, choose Outlook() or Exchange().
    4. If you're prompted for an Outlook profile, indicate which one you want to use
    5. In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next.
    6. Give the linked table a name, then click Finish.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-04-2011, 10:28 AM
  2. Linking accdb to Outlook Contacts folder
    By Craig in forum Import/Export Data
    Replies: 1
    Last Post: 02-14-2011, 05:51 PM
  3. MS Access / MS Outlook Linking
    By foxtrot in forum Access
    Replies: 1
    Last Post: 11-30-2010, 10:50 AM
  4. Outlook to Access
    By Aubreylc in forum Import/Export Data
    Replies: 1
    Last Post: 01-25-2010, 09:37 AM
  5. Replies: 0
    Last Post: 04-17-2009, 11:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums