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 - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Transferring a two column excel file into outlook



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old December 5th 07, 07:53 AM posted to microsoft.public.outlook
Condo
external usenet poster
 
Posts: 2
Default Transferring a two column excel file into outlook

Is there a simple way to transfer an excel file which has two
columns ,one for names the other for phone numbers, into my outlook
address book? I have a excel file with over a hundred such entries
and would rather not enter them individually, surly there is a simple
way to do this. Any suggestions?
  #2  
Old December 5th 07, 01:34 PM posted to microsoft.public.outlook
Brian Tillman
external usenet poster
 
Posts: 17,452
Default Transferring a two column excel file into outlook

Condo wrote:

Is there a simple way to transfer an excel file which has two
columns ,one for names the other for phone numbers, into my outlook
address book? I have a excel file with over a hundred such entries
and would rather not enter them individually, surly there is a simple
way to do this. Any suggestions?


Into the Outlook Address Book? No, since Outlook doesn't keep any
information there. Into a Contacts folder? Sure. FileImport and
ExportImport from another program or file. Make sure the columns are named
exactly as Outlook expects them to be named and make sure you name the range
as well if it's an XLS file and not a CSV file. The import will create new
contacts, however, and won't augment existing contacts.
--
Brian Tillman [MVP-Outlook]

 




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
Transferring .dbx file from one OE6 to Another Keith Willcocks Outlook Express 7 August 31st 07 07:56 PM
Getting Excel file properties Using Outlook Gleiken Outlook and VBA 3 November 15th 06 06:07 AM
how do i import dates from an excel column to outlook calendar KYM Outlook - Calandaring 1 July 7th 06 03:40 AM
Transferring contacts from OAB file [email protected] Outlook - General Queries 3 May 28th 06 10:14 PM
excel file type missing from import a file window in outlook xanadufl Outlook - Using Contacts 9 February 28th 06 09:55 AM


All times are GMT +1. The time now is 11:23 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.