|
| 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 | Search this Thread | Display Modes |
|
#1
June 1st 06, 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 
|
| Ads |
|
#2
June 1st 06, 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 06, 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 06, 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 06, 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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting contacts to Excel | deaville | Outlook Express | 4 | May 19th 06 11:36 PM |
| Exporting Excel Contacts to Outlook - Want to Change the Display | MKC | Outlook - Using Contacts | 4 | March 22nd 06 06:22 PM |
| exporting mail to excel | bobf | Outlook - General Queries | 1 | March 20th 06 01:10 PM |
| Exporting addresses to Excel | stevemarston | Outlook - Using Contacts | 0 | March 15th 06 12:30 PM |
| Exporting Contacts from Outlook emails don't go thru into Excel | neilccarter | Outlook - Using Contacts | 1 | January 18th 06 05:58 AM |
Linear Mode
