Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access/Outlook

Discussion in 'Information Technology' started by Phil Hellmuth, Jul 28, 2006.

  1. Phil Hellmuth

    Phil Hellmuth
    Expand Collapse
    Guest

    Is it possible to link tables from Outlook into Access?
     
  2. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "Phil Hellmuth" <billort@pacbell.net> wrote in message
    news:N089g.71489$F_3.42925@newssvr29.news.prodigy.net...
    > Is it possible to link tables from Outlook into Access?


    Not directly. Outlook's data structure differs significantly from Access's.
    If you export Outlook's Contacts to an Access table and include the 128
    character GUID string which Outlook uses as an identifier (Key), you can
    open and read the Outlook data from an Access form. Keeping the 2 in sync is
    not directly possible.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  3. Arno R

    Arno R
    Expand Collapse
    Guest

    I have been testing some Access <=> Outlook possibilities this week.
    Link tables <> Exchange() works, and one can link very easy.

    The link is live, so data is 'in sync'. Problem however is you don't always get all the fields you need...
    I need to get Outlook appointments to Access and to my surprise I *can* link but I *don't* get the Date not the Start en EndTime.
    I see all kind of MAPI fields including subject, but not the relevant field need.
    For contacts, Inbox and such the links work better.
    So I guess using the link option depends on what you need.
    Also look at http://www.outlookcode.com/d/database.htm#sync for relevant info.

    Arno R

    "Arvin Meyer [MVP]" <a@m.com> schreef in bericht news:uS%23vXmpdGHA.2188@TK2MSFTNGP05.phx.gbl...
    > "Phil Hellmuth" <billort@pacbell.net> wrote in message
    > news:N089g.71489$F_3.42925@newssvr29.news.prodigy.net...
    >> Is it possible to link tables from Outlook into Access?

    >
    > Not directly. Outlook's data structure differs significantly from Access's.
    > If you export Outlook's Contacts to an Access table and include the 128
    > character GUID string which Outlook uses as an identifier (Key), you can
    > open and read the Outlook data from an Access form. Keeping the 2 in sync is
    > not directly possible.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    >
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    By keeping the data in sync, I meant both ways. Outlook can write to Access,
    but Access doesn't do a good job of updating Outlook. I have been able to do
    things like fill an Outlook list box with data from an Access query. I have
    some code on my web page that demonstrates writing an appointment from
    Access to Outlook. I also wrote an article a couple of years ago in Access
    Advisor magazine. The code:

    http://www.datastrat.com/Download/OutlookAppointment.zip
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access


    "Arno R" <arraNOcomSPAM@tiscali.nl> wrote in message
    news:44660e1b$0$2022$ba620dc5@text.nova.planet.nl...
    I have been testing some Access <=> Outlook possibilities this week.
    Link tables <> Exchange() works, and one can link very easy.

    The link is live, so data is 'in sync'. Problem however is you don't always
    get all the fields you need...
    I need to get Outlook appointments to Access and to my surprise I *can* link
    but I *don't* get the Date not the Start en EndTime.
    I see all kind of MAPI fields including subject, but not the relevant field
    need.
    For contacts, Inbox and such the links work better.
    So I guess using the link option depends on what you need.
    Also look at http://www.outlookcode.com/d/database.htm#sync for relevant
    info.

    Arno R

    "Arvin Meyer [MVP]" <a@m.com> schreef in bericht
    news:uS%23vXmpdGHA.2188@TK2MSFTNGP05.phx.gbl...
    > "Phil Hellmuth" <billort@pacbell.net> wrote in message
    > news:N089g.71489$F_3.42925@newssvr29.news.prodigy.net...
    >> Is it possible to link tables from Outlook into Access?

    >
    > Not directly. Outlook's data structure differs significantly from

    Access's.
    > If you export Outlook's Contacts to an Access table and include the 128
    > character GUID string which Outlook uses as an identifier (Key), you can
    > open and read the Outlook data from an Access form. Keeping the 2 in sync

    is
    > not directly possible.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    >
     
  5. Gunnarh

    Gunnarh
    Expand Collapse
    Guest

    Even Link tables <> Outlook|Contacts works. The big problem for me is that
    the "Display as" field used as the email address alias in Outlook is the key
    field of the table linked... This implies that no item with a null "Display
    as" field will be linked into Access. This is the central problem... How
    could you change to another key field? Outlook must use an internal index as
    key field but that one is not utilised in the linked table. The "Display as"
    field is probably used in Outlok to distinguish items to present in
    addressing email dialogs of Outlook, so you would not dare to change it even
    if you could...

    "Arno R" wrote:

    > I have been testing some Access <=> Outlook possibilities this week.
    > Link tables <> Exchange() works, and one can link very easy.
    >
    > The link is live, so data is 'in sync'. Problem however is you don't always get all the fields you need...
    > I need to get Outlook appointments to Access and to my surprise I *can* link but I *don't* get the Date not the Start en EndTime.
    > I see all kind of MAPI fields including subject, but not the relevant field need.
    > For contacts, Inbox and such the links work better.
    > So I guess using the link option depends on what you need.
    > Also look at http://www.outlookcode.com/d/database.htm#sync for relevant info.
    >
    > Arno R
    >
    > "Arvin Meyer [MVP]" <a@m.com> schreef in bericht news:uS%23vXmpdGHA.2188@TK2MSFTNGP05.phx.gbl...
    > > "Phil Hellmuth" <billort@pacbell.net> wrote in message
    > > news:N089g.71489$F_3.42925@newssvr29.news.prodigy.net...
    > >> Is it possible to link tables from Outlook into Access?

    > >
    > > Not directly. Outlook's data structure differs significantly from Access's.
    > > If you export Outlook's Contacts to an Access table and include the 128
    > > character GUID string which Outlook uses as an identifier (Key), you can
    > > open and read the Outlook data from an Access form. Keeping the 2 in sync is
    > > not directly possible.
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > >

    >
     
  6. Patrick

    Patrick
    Expand Collapse
    Guest

    Hi, Am totally new to this Newsgroup but within 5 mins I find this article
    which seems to be about doing precisely what I want to do !! In summary you
    seem to be saying that Modifying or Creating appointemnts in an Access Table
    and linking them to outlook, rather thanthe other way around is a problem ?

    I have also noted that by linking I can get visability of only certain
    Outlook fields in Access, why is this and does anyone know how I can also get
    at least the start and end time of a meeting ?

    thanks in advance ..

    Patrick

    "Gunnarh" wrote:

    > Even Link tables <> Outlook|Contacts works. The big problem for me is that
    > the "Display as" field used as the email address alias in Outlook is the key
    > field of the table linked... This implies that no item with a null "Display
    > as" field will be linked into Access. This is the central problem... How
    > could you change to another key field? Outlook must use an internal index as
    > key field but that one is not utilised in the linked table. The "Display as"
    > field is probably used in Outlok to distinguish items to present in
    > addressing email dialogs of Outlook, so you would not dare to change it even
    > if you could...
    >
    > "Arno R" wrote:
    >
    > > I have been testing some Access <=> Outlook possibilities this week.
    > > Link tables <> Exchange() works, and one can link very easy.
    > >
    > > The link is live, so data is 'in sync'. Problem however is you don't always get all the fields you need...
    > > I need to get Outlook appointments to Access and to my surprise I *can* link but I *don't* get the Date not the Start en EndTime.
    > > I see all kind of MAPI fields including subject, but not the relevant field need.
    > > For contacts, Inbox and such the links work better.
    > > So I guess using the link option depends on what you need.
    > > Also look at http://www.outlookcode.com/d/database.htm#sync for relevant info.
    > >
    > > Arno R
    > >
    > > "Arvin Meyer [MVP]" <a@m.com> schreef in bericht news:uS%23vXmpdGHA.2188@TK2MSFTNGP05.phx.gbl...
    > > > "Phil Hellmuth" <billort@pacbell.net> wrote in message
    > > > news:N089g.71489$F_3.42925@newssvr29.news.prodigy.net...
    > > >> Is it possible to link tables from Outlook into Access?
    > > >
    > > > Not directly. Outlook's data structure differs significantly from Access's.
    > > > If you export Outlook's Contacts to an Access table and include the 128
    > > > character GUID string which Outlook uses as an identifier (Key), you can
    > > > open and read the Outlook data from an Access form. Keeping the 2 in sync is
    > > > not directly possible.
    > > > --
    > > > Arvin Meyer, MCP, MVP
    > > > Microsoft Access
    > > > Free Access downloads
    > > > http://www.datastrat.com
    > > > http://www.mvps.org/access
    > > >
    > > >

    > >
     

Share This Page