+ Reply to Thread
Results 1 to 4 of 4

Grab Outlook data from Access

  1. #1
    shanew
    Guest

    Grab Outlook data from Access

    Hi,

    I have a need to do the following.

    I want to save information directly from the Outlook to my Access database.

    When Outlook is open and an email has been composed and is ready to send ...
    in another application (MS Access), I need to somehow get the to: and cc:
    values from the Outlook email into my Access database (using VBA).
    Does anyone know if this can be done?

    Thanks for any possible tips.

  2. #2
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    re: Grab Outlook data from Access

    try creating a link table,

    then change the input to outlook at the bottom and fiddle it from there
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  3. #3
    shanew
    Guest

    Re: Grab Outlook data from Access

    Hi mac sorry but i didn't get your concept.......i am also created a link table which type of input i need to change..

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

    Re: Grab Outlook data from Access

    You can use Application.ItemSend event to process the outgoing messages.

    Get some information from this site:
    http://www.outlookcode.com/article.aspx?ID=25
    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