PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Interoperability Export to excel

Reply

Export to excel

 
Thread Tools Rate Thread
Old 03-12-2003, 02:12 PM   #1
Nima
Guest
 
Posts: n/a
Default Export to excel


My problem is:

I exported my Ms outlook 2002 contacts to excel 2002 and
I have all standard fields like "name" , "company" and
others but I could not export "user-defined fields in
this item" or "user-defined fields in this folder" that I
create under "all fields" tab.

is there any body know how I can use these fields in
excel or access? or how can export them to excel or
access?

thank you very much
  Reply With Quote
Old 04-12-2003, 02:28 PM   #2
Sue Mosher [MVP]
Guest
 
Posts: n/a
Default Re: Export to excel

Outlook doesn't support exporting custom fields. 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.

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

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Nima" <anonymous@discussions.microsoft.com> wrote in message news:0bc301c3b9a7$7247c910$a301280a@phx.gbl...
> My problem is:
>
> I exported my Ms outlook 2002 contacts to excel 2002 and
> I have all standard fields like "name" , "company" and
> others but I could not export "user-defined fields in
> this item" or "user-defined fields in this folder" that I
> create under "all fields" tab.
>
> is there any body know how I can use these fields in
> excel or access? or how can export them to excel or
> access?
>
> thank you very much

  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