PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Form Programming import access database in my own contacts form

Reply

import access database in my own contacts form

 
Thread Tools Rate Thread
Old 12-06-2006, 08:11 PM   #1
=?Utf-8?B?RWxzZQ==?=
Guest
 
Posts: n/a
Default import access database in my own contacts form


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?
  Reply With Quote
Old 12-06-2006, 08:29 PM   #2
Sue Mosher [MVP-Outlook]
Guest
 
Posts: n/a
Default Re: import access database in my own contacts form

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Else" <Else@discussions.microsoft.com> wrote in message news:B0372D85-C3C7-4C49-8C47-2EA89A0D4EF8@microsoft.com...
>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?

  Reply With Quote
Old 12-06-2006, 09:35 PM   #3
Hollis Paul [MVP - Outlook]
Guest
 
Posts: n/a
Default Re: import access database in my own contacts form

In article <B0372D85-C3C7-4C49-8C47-2EA89A0D4EF8@microsoft.com>,
=?Utf-8?B?RWxzZQ==?= wrote:
> 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.

--
Hollis Paul
Mukilteo, WA USA


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off