A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I export custom fields into excel?



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old September 12th 06, 12:15 AM posted to microsoft.public.outlook
Sarah S.
external usenet poster
 
Posts: 2
Default How do I export custom fields into excel?

THANK YOU Marianne!

I was going crazy trying to figure this out!

Of course... this should be integrated into the product's export process...
but at least now I have a temporary fix.

Sarah S.

"Marianne Seckel" wrote:

If you only want to export the custom data to excel, you can do this by
creating a custom view and copying the selected items to an excel
spreadsheet.
You can define a new view or customize an existing view. be sure it is in
table format. (check you Outlook HELP for info on custom views)

In the table format, choose the standard contact fields you need from
"frequently used fields and the appropriate custom fields from the form or
user-defined fields option.)
After you have selected the fields you want and have them in the right
order, your view should look very similar to an excel spreadsheet. Simply
choose the contacts you want, copy to the clipboard (edit|copy or CNTL C),
then paste (edit|paste or CNTL V) into an excel spreadsheet and manipulate
as needed.

Marianne Seckel
Project Manager
Smith Seckman Reid, Inc.


"MT" wrote in message
...
I want to export my Outlook contacts into excel, but it doesn't seem to

export the custom fields I've added. When I look at map fields, it only has
the standard ones. Any idea how to include the custom fields?



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
copy custom task with custom fields VinceGSMW Outlook - General Queries 3 May 31st 06 04:11 AM
Map fields during export Lacie Outlook - Calandaring 1 April 14th 06 11:02 PM
How do I export a contacts list which includes custom fields CarrieW Outlook - Using Contacts 2 March 28th 06 08:47 PM
Mapping Fields During Import from Excel Phil Rabichow Outlook - Using Contacts 2 March 11th 06 07:09 PM
Import from excel into a custom form and fields in Contacts John Outlook - Using Contacts 1 February 1st 06 03:37 PM


All times are GMT +1. The time now is 11:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.