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

Addresses from Excel



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 15th 09, 11:54 PM posted to microsoft.public.outlook,microsoft.public.outlook.general
AJS
external usenet poster
 
Posts: 73
Default Addresses from Excel

Hi,
I got an Microsoft Excel file with list of emails addresses in it.
Is it possible to import or somehow get the email addresses into Outlook so
that I don't have to type them in?

Also, since I would like them in a group can I do that at the same time?

Thanks,
AJS


Ads
  #2  
Old January 16th 09, 10:57 AM posted to microsoft.public.outlook,microsoft.public.outlook.general
Lobster
external usenet poster
 
Posts: 23
Default Addresses from Excel

AJS wrote:

I got an Microsoft Excel file with list of emails addresses in it.
Is it possible to import or somehow get the email addresses into Outlook so
that I don't have to type them in?


Use File - Import and follow the Wizard: probably best to try it out
and see how you get on; then come back with specific queries if you
can't get it working.

David
  #3  
Old January 16th 09, 03:49 PM posted to microsoft.public.outlook,microsoft.public.outlook.general
AJS
external usenet poster
 
Posts: 73
Default Addresses from Excel

Thanks,
I imported the files and ran into another problem.
I do not have an "area code" column in Outlook.
Since I did not know how to do this, I combined the two columns (area code
and phone numbers). Unfortunately Outlook did not see the new Excel column.
Any suggestions?
Thanks,
AJS

"Lobster" wrote in message
...
| AJS wrote:
|
| I got an Microsoft Excel file with list of emails addresses in it.
| Is it possible to import or somehow get the email addresses into Outlook
so
| that I don't have to type them in?
|
| Use File - Import and follow the Wizard: probably best to try it out
| and see how you get on; then come back with specific queries if you
| can't get it working.
|
| David


  #4  
Old January 16th 09, 03:54 PM posted to microsoft.public.outlook,microsoft.public.outlook.general
Brian Tillman [MVP - Outlook]
external usenet poster
 
Posts: 4,874
Default Addresses from Excel

"AJS" wrote in message
...

I got an Microsoft Excel file with list of emails addresses in it.
Is it possible to import or somehow get the email addresses into Outlook
so
that I don't have to type them in?


FileImport and ExportImport from a file

Also, since I would like them in a group can I do that at the same time?


Outlook doesn't have anything called "groups". Do you mean a Distribution
List? If so, then in Outlook, click NewDistribution List, give it a name,
click Select Members. Now open your Excel file and select the addresses (or
name/address pairs), click EditCopy. Go back to the Select Members wizard
and paste the clipboard into the Members field. Click OK. Click Save and
Close.
--
Brian Tillman [MVP-Outlook]

  #5  
Old January 16th 09, 04:32 PM posted to microsoft.public.outlook,microsoft.public.outlook.general
AJS
external usenet poster
 
Posts: 73
Default Addresses from Excel

Thanks,


"Brian Tillman [MVP - Outlook]" wrote in message
...
| "AJS" wrote in message
| ...
|
| I got an Microsoft Excel file with list of emails addresses in it.
| Is it possible to import or somehow get the email addresses into Outlook
| so
| that I don't have to type them in?
|
| FileImport and ExportImport from a file
|
| Also, since I would like them in a group can I do that at the same time?
|
| Outlook doesn't have anything called "groups". Do you mean a Distribution
| List? If so, then in Outlook, click NewDistribution List, give it a
name,
| click Select Members. Now open your Excel file and select the addresses
(or
| name/address pairs), click EditCopy. Go back to the Select Members
wizard
| and paste the clipboard into the Members field. Click OK. Click Save and
| Close.
| --
| 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
Importing from Excel - EM Addresses missing . NFJim Outlook - Using Contacts 2 April 9th 07 05:10 PM
Importing email addresses from excel Cazz Outlook - Using Contacts 1 January 19th 07 07:31 AM
Using email addresses from an Excel spreadsheet? Jan Outlook Express 3 October 4th 06 02:37 PM
Importing addresses from an Excel spreadsheet pddmcse Outlook - Using Contacts 1 April 27th 06 09:17 AM
Exporting addresses to Excel stevemarston Outlook - Using Contacts 0 March 15th 06 01:30 PM


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