 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / October 2006File As filed not exporting
When I export contacts either into Excel or Access, the File As field is not exporting. Is there a way to get this to export. What I need to do is export the file, modify it to add custom field and import it back and have the 'File As' keep its setting. I am able to export and import custom fields but dont see the 'File As' field. The File As field does not exist as a separate data field. It is a field derived from its separate name element fields. Those are what you export.  SignatureRuss Valentine [MVP-Outlook] > When I export contacts either into Excel or Access, the File As field is > not [quoted text clipped - 5 lines] > dont > see the 'File As' field. Is there anyway I can get this infomation out of outlook and imported back in? > The File As field does not exist as a separate data field. It is a field > derived from its separate name element fields. Those are what you export. [quoted text clipped - 7 lines] > > dont > > see the 'File As' field. I don't understand your question. As I said, the information is all there in the name fields. SignatureRuss Valentine [MVP-Outlook] > Is there anyway I can get this infomation out of outlook and imported back > in? [quoted text clipped - 11 lines] >> > dont >> > see the 'File As' field. I exported the data in an Excel and Access format, the File As infomation is not being exported. I can see the infomation in the fields in Outlook on the main contact screen and on the All Fields - Freq Used Fields. For example, I have a contact, in the file as field I have one item, 3M, that info is not in either export. Hello Russ Valentine [MVP-Outlook], > I don't understand your question. As I said, the information is all > there in the name fields. I already answered that. Derived fields do not export. Their individual names elements are exported. SignatureRuss Valentine [MVP-Outlook] >I exported the data in an Excel and Access format, the File As infomation >is not being exported. I can see the infomation in the fields in Outlook on [quoted text clipped - 5 lines] >> I don't understand your question. As I said, the information is all >> there in the name fields. Thank you but is there any way to get the data in this field, via VBA or VB, or some other type of script. Hello Russ Valentine [MVP-Outlook], > I already answered that. Derived fields do not export. Their > individual names elements are exported. Probably, but that is a question for a programming group. The only code I know of is to change the File As... field within Outlook: http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002 SignatureRuss Valentine [MVP-Outlook] > Thank you but is there any way to get the data in this field, via VBA or > VB, or some other type of script. [quoted text clipped - 3 lines] >> I already answered that. Derived fields do not export. Their >> individual names elements are exported. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.