Exporting Outlook Contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RH - 22 Mar 2006 16:16 GMT

I am using Outlook 2003 (Windows XP). I've created a public contact list
with a custom form. Before Outlook 2003, I had no problems exporting the
information to Access so that I could manipulate my mailing data. Now when I
export to Access not all of the contacts export. Any suggestions?

Reply to this Message

Sue Mosher [MVP-Outlook] - 22 Mar 2006 17:57 GMT

What method are you using to export? Outlook doesn't support exporting from custom form items. Quick and dirty method:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. Paste to Excel.

If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm .

Signature

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

>I am using Outlook 2003 (Windows XP). I've created a public contact list
> with a custom form. Before Outlook 2003, I had no problems exporting the
> information to Access so that I could manipulate my mailing data. Now when I
> export to Access not all of the contacts export. Any suggestions?

Reply to this Message

Rate this thread: