 |
 | 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 / June 2006Exporting Contacts into Excel
Hi - I am trying to export into Excel but cannot locate the field "Full Name". It shows up in Outlook itself but not when I am exporting it. It does export over First Name & Last Name columns but not Full Name and I want that more than the other two. If someone could let me know how to get this field when exporting into Excel, it would be great. Thanks Can't you construct the full name from First and Last with a formula?  SignatureSue 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 > Hi - I am trying to export into Excel but cannot locate the field "Full > Name". It shows up in Outlook itself but not when I am exporting it. It does [quoted text clipped - 5 lines] > > Thanks Not sure how to do this - could you give me instructions/formula to do this and the formula would be for Excel once I export the file? > Can't you construct the full name from First and Last with a formula? > [quoted text clipped - 7 lines] > > > > Thanks If you want to put the data in cells A1 and B1 together, it would be: = CONCATENATE(A1," ",B1) SignatureSue 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 > Not sure how to do this - could you give me instructions/formula to do this > and the formula would be for Excel once I export the file? [quoted text clipped - 11 lines] >> > >> > Thanks Sue - you are the greatest. This isn't the first time you have helped me and its greatly appreciated. Take care & Thanks!! > If you want to put the data in cells A1 and B1 together, it would be: > [quoted text clipped - 15 lines] > >> > > >> > Thanks |
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.