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

import contacts from Excel



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 5th 08, 10:38 PM posted to microsoft.public.outlook.contacts
Marilyn
external usenet poster
 
Posts: 28
Default import contacts from Excel

I have created two Contact folders under the Primary Contact folder under
Public Folders. I have an Excel spreadsheet that I would like to import data
into them. During the import process, I do not see Public Folders as a
choice (only my mailbox and Personal Folders). Is it possible to do this?
And, from all the other messages I'm seeing, is this a difficult process? I
have an Exchange 2003 server, client users are on Outlook 2002 and 2003 and
it's an Excel 2002 document. Thanks, Marilyn
  #2  
Old June 6th 08, 01:13 AM posted to microsoft.public.outlook.contacts
Judy Gleeson \(MVP Outlook\)[_226_]
external usenet poster
 
Posts: 1
Default import contacts from Excel

Make a Contacts Folder in your Mailbox as the destination. Once the data is
in, you can drag the folder to the Public Folders.

Improting from Excel works fine as long as you name the range and close
Excel, then use file import in Outlook.
--

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au
Outlook 2003 user? Read "7 settings all Outlook 2003 users should change"
on my website.

..
"Marilyn" wrote in message
...
I have created two Contact folders under the Primary Contact folder under
Public Folders. I have an Excel spreadsheet that I would like to import
data
into them. During the import process, I do not see Public Folders as a
choice (only my mailbox and Personal Folders). Is it possible to do this?
And, from all the other messages I'm seeing, is this a difficult process?
I
have an Exchange 2003 server, client users are on Outlook 2002 and 2003
and
it's an Excel 2002 document. Thanks, Marilyn



  #3  
Old June 6th 08, 06:58 PM posted to microsoft.public.outlook.contacts
Marilyn
external usenet poster
 
Posts: 28
Default import contacts from Excel

Judy - I'm having a heck of a time with naming the range. I've been in Excel
help and on the Excel discussion group. two replies took me to documents
that basically say the same thing as Excel help. I've taken the suggested
steps a dozen times and two or three different ways. End result is still the
error that the document has no named ranges and to use Excel to name the
range of data I want to import. Any suggestions? Thanks

"Judy Gleeson (MVP Outlook)" wrote:

Make a Contacts Folder in your Mailbox as the destination. Once the data is
in, you can drag the folder to the Public Folders.

Improting from Excel works fine as long as you name the range and close
Excel, then use file import in Outlook.
--

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au
Outlook 2003 user? Read "7 settings all Outlook 2003 users should change"
on my website.

..
"Marilyn" wrote in message
...
I have created two Contact folders under the Primary Contact folder under
Public Folders. I have an Excel spreadsheet that I would like to import
data
into them. During the import process, I do not see Public Folders as a
choice (only my mailbox and Personal Folders). Is it possible to do this?
And, from all the other messages I'm seeing, is this a difficult process?
I
have an Exchange 2003 server, client users are on Outlook 2002 and 2003
and
it's an Excel 2002 document. Thanks, Marilyn




  #4  
Old June 6th 08, 07:04 PM posted to microsoft.public.outlook.contacts
Gordon
external usenet poster
 
Posts: 1,554
Default import contacts from Excel

"Marilyn" wrote in message
...
Judy - I'm having a heck of a time with naming the range. I've been in
Excel
help and on the Excel discussion group. two replies took me to documents
that basically say the same thing as Excel help. I've taken the suggested
steps a dozen times and two or three different ways. End result is still
the
error that the document has no named ranges and to use Excel to name the
range of data I want to import. Any suggestions? Thanks


All you do is highlight the data and type the name in the box at the top
left hand side of the window, next to the formula bar.....

  #5  
Old June 6th 08, 07:15 PM posted to microsoft.public.outlook.contacts
Marilyn
external usenet poster
 
Posts: 28
Default import contacts from Excel

Well, that's what I did - several times. It seems so simple and I don't get
why it won't work.

"Gordon" wrote:

"Marilyn" wrote in message
...
Judy - I'm having a heck of a time with naming the range. I've been in
Excel
help and on the Excel discussion group. two replies took me to documents
that basically say the same thing as Excel help. I've taken the suggested
steps a dozen times and two or three different ways. End result is still
the
error that the document has no named ranges and to use Excel to name the
range of data I want to import. Any suggestions? Thanks


All you do is highlight the data and type the name in the box at the top
left hand side of the window, next to the formula bar.....


  #6  
Old June 6th 08, 08:59 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default import contacts from Excel

To avoid the issue of "Named Range" - just save the worksheet as a CSV file
and import that instead.

If you're going to do this on an on-going basis - one of our products may be
of interest:
http://www.contactgenie.com/cg20features.htm
(will import directly into any contact folder - Exch Mailbox, PubFldrs or
PST. You also have the option with DataPorter to "update" pre-existing
contacts)

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



"Marilyn" wrote in message
...
Well, that's what I did - several times. It seems so simple and I don't
get
why it won't work.

"Gordon" wrote:

"Marilyn" wrote in message
...
Judy - I'm having a heck of a time with naming the range. I've been in
Excel
help and on the Excel discussion group. two replies took me to
documents
that basically say the same thing as Excel help. I've taken the
suggested
steps a dozen times and two or three different ways. End result is
still
the
error that the document has no named ranges and to use Excel to name
the
range of data I want to import. Any suggestions? Thanks


All you do is highlight the data and type the name in the box at the top
left hand side of the window, next to the formula bar.....




 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
trying to import from excel to contacts worker bee Outlook - Using Contacts 12 October 12th 07 02:52 PM
trying to import from excel to contacts PHSMITH Outlook - Using Contacts 0 February 21st 07 11:55 PM
import contacts from excel Gareth Outlook - Using Contacts 2 February 16th 07 01:56 AM
trying to import from excel to contacts bhalla Outlook - Using Contacts 0 June 22nd 06 12:31 PM
import contacts from excel LSChaefer33 Outlook - General Queries 1 January 18th 06 10:38 PM


All times are GMT +1. The time now is 09:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.