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

upload e-mail addresses from excel file



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 16th 07, 11:34 PM posted to microsoft.public.outlook.contacts
Colleen
external usenet poster
 
Posts: 11
Default upload e-mail addresses from excel file

I have a list of almost 300 clients e-mail addresses. Does anyone know how to
upload them from excel format into Outlook without have to do one by one?
Ads
  #2  
Old July 16th 07, 11:39 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default upload e-mail addresses from excel file

Create a named range in the spreadsheet containing the data you want to import, then use File | Import and Export in Outlook.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Colleen" wrote in message ...
I have a list of almost 300 clients e-mail addresses. Does anyone know how to
upload them from excel format into Outlook without have to do one by one?

  #3  
Old July 17th 07, 08:16 AM posted to microsoft.public.outlook.contacts
Gordon
external usenet poster
 
Posts: 1,554
Default upload e-mail addresses from excel file

"Colleen" wrote in message
...
I have a list of almost 300 clients e-mail addresses. Does anyone know how
to
upload them from excel format into Outlook without have to do one by one?


In addition to what Sue said, be aware that if you are using Office 2007,
Outlook will not import from xlsx documents - you will need to save the file
first as an old xls-type file...


 




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
How to import e-mail addresses from Excel to a distribution list. JJBESQ Outlook - Using Contacts 3 December 1st 06 08:30 PM
Birthday Reminders Excel Upload Francesca Outlook - Calandaring 2 April 25th 06 02:27 AM
Upload from excel to calander JC Outlook - Calandaring 3 April 8th 06 07:05 PM
Exporting addresses to Excel stevemarston Outlook - Using Contacts 0 March 15th 06 12:30 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 06:55 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.