PC Review


Reply
Thread Tools Rate Thread

Censur of mapping fields in export ?

 
 
=?Utf-8?B?VG9tYXM=?=
Guest
Posts: n/a
 
      13th Mar 2007
How can I get around Microsofts restrictions of witch fields I can export to
an Excel-file ?
I want to export an email-mapp to an Excel-file and I'm intersted of the
timestamp (time received), but in the mapping-windows is only
Microsoft-choosen-fields shown.
Does anyone know how I can go round this stupid restriction ?
/Tomas
 
Reply With Quote
 
 
 
 
Sue Mosher [MVP-Outlook]
Guest
Posts: n/a
 
      13th Mar 2007
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/d/customimport.htm


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

"Tomas" <(E-Mail Removed)> wrote in message news:4E4CD1AB-1DCA-48E1-B1F3-(E-Mail Removed)...
> How can I get around Microsofts restrictions of witch fields I can export to
> an Excel-file ?
> I want to export an email-mapp to an Excel-file and I'm intersted of the
> timestamp (time received), but in the mapping-windows is only
> Microsoft-choosen-fields shown.
> Does anyone know how I can go round this stupid restriction ?
> /Tomas

 
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Fields or Mapping Fields to Contact Information cpatte7372 Microsoft Outlook Contacts 1 22nd May 2009 11:54 AM
export re-order input fields to export file [csv] madisonpete Microsoft Excel Worksheet Functions 0 30th Nov 2007 03:51 PM
export xml source mapping rcmail14872@yahoo.com Microsoft Excel Programming 1 6th Dec 2006 03:18 PM
Mapping Fields =?Utf-8?B?Sm9zZSBBbGVtYW4=?= Microsoft Access VBA Modules 1 4th Nov 2005 05:02 PM
outlook 2003 not showing custom fields for mapping fields on impor =?Utf-8?B?U2tpZV9JbmM=?= Microsoft Outlook Form Programming 1 3rd Feb 2005 01:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:10 PM.