Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 11th, 2003, 09:53 AM
Authorized User
 
Join Date: Jun 2003
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linking Outlook and Access

Does any know how to automatically (or via a button) make information from an Outlook e-mail populate a record in Access?

John
__________________
John
 
Old August 12th, 2003, 10:04 AM
Authorized User
 
Join Date: Jul 2003
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The easiest way I find is to set up a linked table to the folder you want to use e.g. Inbox or Contacts. Use Exchange on the linking options.

the linked table containing the email fields can be used like any other table.

The other way is to set up an ADO connection which can be quite complex.

HTH

Cheers Ray





Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Access to Excel ryani1111 VB How-To 1 August 4th, 2008 10:47 AM
Linking Access to Active Directory Brendan Bartley Access 2 November 28th, 2007 05:42 AM
Linking JSP and Access Jeevan04 Access 0 December 19th, 2004 10:02 PM
Linking files to an access table william.murray Access VBA 0 November 5th, 2004 10:00 AM
Error When linking Oracle Tables to Access mtullock Access 2 January 16th, 2004 10:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.