Solved

Add field when importing from Excel into Outlook

Posted on 2006-06-17
1
162 Views
Last Modified: 2010-04-08
I am importing a list of contacts from Excel into Outlook 2003. I want to import to the "Nickname" field, but when I get to the "Map Custom Fields" window, it isn't listed. How do you add fields to be available in "Map Custom Fields"?
0
Comment
Question by:ldblake
1 Comment
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 17020434
I haven't been able to discover a way to change the list of Outlook fields available to be mapped to.  I see two solutions.  One, write your own improt routine using VBA.  Two, import the nickname field from Excel to one of the four user fields in Outlook and then use a simple macro to move that data to the nickname field.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Get an idea of what you should include in an email disclaimer with these Top 5 email disclaimer tips.
Outlook Free & Paid Tools
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now