A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

importing contacts in outlook



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2007, 05:39 PM posted to microsoft.public.outlook.contacts
outlook
external usenet poster
 
Posts: 25
Default importing contacts in outlook

When I go through the importing process, the name is messed up. For example,
if the name is Peace Lutheran School, it will be listed as School, Pease
Lutheran. I have tried different mapping scenarios, but nothing works.
  #2  
Old March 5th, 2007, 06:39 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default importing contacts in outlook

When importing a value to the "Name" field, Outlook will automatically
determine what the first and last name components of the "name" are from
which the "File As" field is created as per the rule set.

In your example - the issue is that you want the name "Peace Lutheran
School" to be one component which would require that you explicity map these
kinds of names to either the "first name" or "last name" component of a
name which would solve your problem. However, if the data you are importing
is a mixture of regular names (i.e. John Doe) and single names as per your
example - there is no way for Outlook to know which is which.

One option availble, if your main import file contains a mixture of name
"types" (i.e. John Doe and Peace Lutheran School) - split the file into 2
based on name type. Import each file with it's own field map. Otherwise, if
all names are of the type "Peace..." then simply map the field to either the
first or last name element instead of to the full name.

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


"outlook" wrote in message
...
When I go through the importing process, the name is messed up. For
example,
if the name is Peace Lutheran School, it will be listed as School, Pease
Lutheran. I have tried different mapping scenarios, but nothing works.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.