Exporting Outlook Contacts
 

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?

Exporting Outlook Contacts
 

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/legaul...4/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 .

--
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

"RH" wrote in message ...
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?