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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|