General discussion

Locked

mail from database

By bucky_day ·
Can I connect Outlook or Exchange with my existing customer database? How would that be done? Can Exchange itself be used as a database?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

mail from database

by maxwell edison In reply to mail from database

For Exchange 5.5, documentation on the Outlook Access Data Transfer utility includes a section on Exchange as a database

Exchange 2000 has an OLE DB driver and, therefore, can be accessed by server applications directly as a database. Exchange 5.5 has an third-party OLE DB driver for use with ADO as well.

See this link for details:

http://www.intouchsoftware.com/Products/OAXfer/OAXfer.htm

Without programming, you can easily add a table linked to an Outlook or Exchange folder to any Access database, using drivers built into Office 2000, by following these steps:

In Access, click the New Table button to add a new table.

In the New Table dialog, choose Link Table, then click OK.

In the Link dialog, under Files of type,choose Outlook() or Exchange().

If you're prompted for an Outlook profile, indicate which one you want to use
In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next.

Give the linked table a name, then click Finish.

See Microsoft article 196873 titled, "OL2000 - How to Use Your Outlook Items with Other Office Programs".

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q196873

Unfortunately, this method has at least three limitations:

The linked table ignores any custom fields.

Not all address fields are linked.

The Home and Office addresses each are listed as one field, while the Business address -- probably whatever is the default mailing address --is parsed into its street, city, etc. components.
Not all fields are included for all items. You can see the fields available by switching to Design View.

There's an article in both the August and September 2000 issues of the Smart Access newsletter that explain how to get around the above limitations and make this method work much better.

http://www.smartaccessnewsletter.com/

Best of luck,

Maxwell

Collapse -

mail from database

by bucky_day In reply to mail from database

Poster rated this answer

Collapse -

mail from database

by bucky_day In reply to mail from database

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums