A Microsoft Outlook email forum. Outlook Banter

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 » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , , , ,

Import fields from Excel go into different Outlook contacts





 
 
Thread Tools Display Modes
  #1  
Old May 3rd 08, 07:35 PM posted to microsoft.public.outlook.contacts
Bob in Norman
external usenet poster
 
Posts: 1
Default Import fields from Excel go into different Outlook contacts

I have defined Names in Excel (Name, Title, Number, Email). When I import
into Outlook, it puts each item into a different Contact. It puts them into
the correct category (Name, Title, Number, Email) but rather than putting the
4 items into one contact, it creates 4 different contacts.
Ads
  #2  
Old May 4th 08, 02:48 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 456
Default Import fields from Excel go into different Outlook contacts

Clear all of your "named ranges" in your Excel worksheet and create only one
that encompasses both the header row (first row with column names) and all
rows that you want to import - no more - no less.

Alternative to dealing with named ranges is save your Excel worksheet as a
CSV file and import that into Outlook instead.

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



"Bob in Norman" Bob in wrote in message
...
I have defined Names in Excel (Name, Title, Number, Email). When I import
into Outlook, it puts each item into a different Contact. It puts them
into
the correct category (Name, Title, Number, Email) but rather than putting
the
4 items into one contact, it creates 4 different contacts.



 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to import excel to outlook with extra fields GABE Outlook - Using Contacts 2 January 31st 08 03:27 AM
Import Error with Excel - Too many fields defined RealGomer Outlook - Calandaring 2 October 26th 06 11:18 PM
Excel import won't recognize zip code fields, others are fine emspooner Outlook - Using Contacts 2 March 21st 06 06:39 PM
Mapping Fields During Import from Excel Phil Rabichow Outlook - Using Contacts 2 March 11th 06 06:09 PM
Import from excel into a custom form and fields in Contacts John Outlook - Using Contacts 1 February 1st 06 02:37 PM


All times are GMT +1. The time now is 05:29 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Car Insurance - Wills - Car Credit - Adult ADD - Loans