import access database in my own contacts form

G

Guest

I made a contacts form, and want to import our customer database from access.
However, I can only do this to the default contacts form from outlook. How
can I import and export from access to a contact form I created?
 
S

Sue Mosher [MVP-Outlook]

Outlook doesn't support importing to a custom form. You'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
H

Hollis Paul [MVP - Outlook]

I made a contacts form, and want to import our customer database from access.
However, I can only do this to the default contacts form from outlook. How
can I import and export from access to a contact form I created?
You can't use the import wizard to import data to a custom form. If you are not
using any User Defined Fields in your custom form, you can import to the
standard form, then run a utility to change the Message Class field to your
custom form name, and they will display in your custom form.

If you have Iuds in your custom form, then you need to use code to do the
import, which can be a real pain if you have lots of fields with data in them.

In either case, you should search on www.outlookcode.com for examples of how to
do all this. Search first on "default" without the quotes to find the article
that tells you how to change the default form to your form and to change the
Message Class field to your custom form name. Then search on "Import", or
perhaps, "Inport" (I can never remember which one of those terms is used by
Microsoft), again without the quotes, to find code examples of importing from
Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top