Addresses from Excel

  • Thread starter Thread starter AJS
  • Start date Start date
A

AJS

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
 
AJS said:
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?
Click to expand...

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
 
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

| 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
 
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?
Click to expand...

File>Import and Export>Import from a file
Also, since I would like them in a group can I do that at the same time?
Click to expand...

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


| |
| > 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?
|
| File>Import and Export>Import 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 New>Distribution List, give it a
name,
| click Select Members. Now open your Excel file and select the addresses
(or
| name/address pairs), click Edit>Copy. 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]
|
 
Back
Top