|
| 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 | Display Modes |
|
#1
June 1st, 2006, 02:35 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Exporting 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 
|
|
#2
June 1st, 2006, 03:09 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Contacts into Excel
Can't you construct the full name from First and Last with a formula?
-- 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 "Anna" wrote in message ... 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
|
|
#3
June 1st, 2006, 04:39 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Contacts into Excel
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? "Sue Mosher [MVP-Outlook]" wrote: Can't you construct the full name from First and Last with a formula? -- 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 "Anna" wrote in message ... 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
|
|
#4
June 1st, 2006, 05:00 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Contacts into Excel
If you want to put the data in cells A1 and B1 together, it would be:
= CONCATENATE(A1," ",B1) -- 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 "Anna" wrote in message ... 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? "Sue Mosher [MVP-Outlook]" wrote: Can't you construct the full name from First and Last with a formula? "Anna" wrote in message ... 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
|
|
#5
June 1st, 2006, 07:19 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Contacts into Excel
Sue - you are the greatest. This isn't the first time you have helped me and
its greatly appreciated. Take care & Thanks!! "Sue Mosher [MVP-Outlook]" wrote: If you want to put the data in cells A1 and B1 together, it would be: = CONCATENATE(A1," ",B1) -- 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 "Anna" wrote in message ... 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? "Sue Mosher [MVP-Outlook]" wrote: Can't you construct the full name from First and Last with a formula? "Anna" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
