Exporting Outlook Contacts

[Guest]

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?

 

[Sue Mosher [MVP-Outlook]]

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 .

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

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