Exporting Contacts into Excel

A

Anna

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
 
S

Sue Mosher [MVP-Outlook]

Can't you construct the full name from First and Last with a formula?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
A

Anna

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

Sue Mosher [MVP-Outlook]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
A

Anna

Sue - you are the greatest. This isn't the first time you have helped me and
its greatly appreciated. Take care & Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top