Importing Fields (Email)

[potter.justin]

I was wondering why when importing a contact list from Excel (or .csv
format), my email fields and display name as fields arent being
imported. I know i can use the map custom fields to get them to
import. As far as i know i am using the default field names
(EmailDisplayName and EmailAddress) as the column headings. Is this a
common problem? is there an easy fix?

 

[Karl Timmermans]

For this response - going to assume that you are letting Outlook "auto-map"
your fields (never a good thing to do without manually checking what exactly
did or did not get mapped).

The proper "default" field names that you are referring to are:

E-mail Address
E-mail Display Name

ergo - if I'm correct in the assumption stated above - the field names you
are using "EmailAddress" and "EmailDisplayName" wouldn't match. Again, to
repeat and stress - it's NEVER a good idea to let Outlook "auto-map" the
fields without at least checking what has been mapped. There is also no need
to go thru the exercise of re-naming field/column names to exactly match
Outlook - just as fast or faster (and far safer) to simply manually map the
fields yourself (via the Map Custom Fields button)

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

 

[potter.justin]

For this response - going to assume that you are letting Outlook "auto-map"
your fields (never a good thing to do without manually checking what exactly
did or did not get mapped).

The proper "default" field names that you are referring to are:

E-mail Address
E-mail Display Name

ergo - if I'm correct in the assumption stated above - the field names you
are using "EmailAddress" and "EmailDisplayName" wouldn't match. Again, to
repeat and stress - it's NEVER a good idea to let Outlook "auto-map" the
fields without at least checking what has been mapped. There is also no need
to go thru the exercise of re-naming field/column names to exactly match
Outlook - just as fast or faster (and far safer) to simply manually map the
fields yourself (via the Map Custom Fields button)

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"http://www.contactgenie.com






- Show quoted text -

Using your headings worked, thanks!

What i am trying to do is make it easy for a user to take a list of
contacts (from another program) run it through a macro i wrote in
excel to clean it up and then import the results into outlook so that
it syncs with their phones ect. I realize you should always check the
mappings, but those additional instructions would confuse many of my
users. I just assumed I was using the default field names, i exported
a contact list from Outlook and that is what came accross.

 

[Karl Timmermans]

Your reasoning for doing what you're doing is certainly sound in terms of
field names.

Just a tidbit of useless trivia for you re: field names:

Outlook uses 2 kinds of field names - external "Display Names" (i.e. E-mail
Address) and internal names (i.e. EmailAddress). The external display names
found in the "Field Chooser" or the mapping process change based on the
language in use so if you were doing this for a multiple regions - your
macro wouldn't work for all. The internal names never change regardless of
language settings but can't be used for "auto-mapping" as you found out.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

For this response - going to assume that you are letting Outlook
"auto-map"
your fields (never a good thing to do without manually checking what
exactly
did or did not get mapped).

The proper "default" field names that you are referring to are:

E-mail Address
E-mail Display Name

ergo - if I'm correct in the assumption stated above - the field names you
are using "EmailAddress" and "EmailDisplayName" wouldn't match. Again, to
repeat and stress - it's NEVER a good idea to let Outlook "auto-map" the
fields without at least checking what has been mapped. There is also no
need
to go thru the exercise of re-naming field/column names to exactly match
Outlook - just as fast or faster (and far safer) to simply manually map
the
fields yourself (via the Map Custom Fields button)

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook
'2000/2007"http://www.contactgenie.com






- Show quoted text -

Using your headings worked, thanks!

What i am trying to do is make it easy for a user to take a list of
contacts (from another program) run it through a macro i wrote in
excel to clean it up and then import the results into outlook so that
it syncs with their phones ect. I realize you should always check the
mappings, but those additional instructions would confuse many of my
users. I just assumed I was using the default field names, i exported
a contact list from Outlook and that is what came accross.