exporting user-defined fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elijah - 08 Dec 2004 18:59 GMT

I'm trying to export a contact database to a file in order to email to
another computer for use elsewhere. The problem is that my user defined
fields are never saved. I can't figure out how this might be done. Any help
would be appreciated.

Thanks

Reply to this Message

Sue Mosher [MVP-Outlook] - 08 Dec 2004 19:04 GMT

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.

Alternatively, copy the entire folder to a new, empty Personal Folders .pst
file.

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

> I'm trying to export a contact database to a file in order to email to
> another computer for use elsewhere. The problem is that my user defined
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

AmyKong - 13 Dec 2004 05:15 GMT

I tried this copy and paste method into Excel. However, the addresses are
displayed in multi-rows when you paste them in Excel. Is there a way to
paste the information of a single contact to a single row in Excel? Any help
you could provide would be greatly appreciated.

> Outlook doesn't support exporting custom fields. Quick and dirty method:
>
[quoted text clipped - 18 lines]
> >
> > Thanks

Reply to this Message

Sue Mosher [MVP-Outlook] - 13 Dec 2004 13:10 GMT

Use a table view that displays each element of the address in its own
column.

Signature

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

>I tried this copy and paste method into Excel. However, the addresses are
> displayed in multi-rows when you paste them in Excel. Is there a way to
[quoted text clipped - 28 lines]
>> >
>> > Thanks

Reply to this Message

AKong - 13 Dec 2004 23:35 GMT

Apologies for being dense about this, but where do I change it to table view.
I have search the Office Online help, but can't find anything on this.
Thanks.

> Use a table view that displays each element of the address in its own
> column.
[quoted text clipped - 31 lines]
> >> >
> >> > Thanks

Reply to this Message

Sue Mosher [MVP-Outlook] - 14 Dec 2004 00:20 GMT

Signature

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

> Apologies for being dense about this, but where do I change it to table
> view.
[quoted text clipped - 42 lines]
>> >> >
>> >> > Thanks

Reply to this Message