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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Exporting contacts to an Excel File
I have created several new fields in my outlook contacts files to fit the
needs of my church office. When trying to export my contacts to an excel file, I am unable to exported the created fields. Any suggestions on how I might get this to work |
Ads |
#2
|
|||
|
|||
Exporting contacts to an Excel File
Outlook doesn't support exporting custom fields directly. 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 The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/article.aspx?ID=23 -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "msguirt" wrote in message ... I have created several new fields in my outlook contacts files to fit the needs of my church office. When trying to export my contacts to an excel file, I am unable to exported the created fields. Any suggestions on how I might get this to work |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Exporting Distribution List to Excel File | Jen | Outlook - Using Contacts | 4 | March 24th 10 08:17 PM |
Exporting from Excel to Contacts | David | Outlook - Using Contacts | 1 | September 26th 06 09:29 PM |
Problem exporting contacts to excel | [email protected] | Outlook - Using Contacts | 4 | June 12th 06 08:36 AM |
Exporting Contacts into Excel | Anna | Outlook - Using Contacts | 4 | June 1st 06 07:19 PM |
Exporting contacts to Excel | deaville | Outlook Express | 4 | May 19th 06 11:36 PM |