Addresses from Excel

MS OFFICE OUTLOOK

Addresses from Excel

Postby AJS » Sat, 17 Jan 2009 07:54:00 GMT

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 



Re: Addresses from Excel

Postby Lobster » Sat, 17 Jan 2009 18:57:17 GMT




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

Re: Addresses from Excel

Postby AJS » Sat, 17 Jan 2009 23:49:02 GMT

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







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



Re: Addresses from Excel

Postby Brian Tillman [MVP - Outlook] » Sat, 17 Jan 2009 23:54:52 GMT






File>Import and Export>Import from a file


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] 


Re: Addresses from Excel

Postby AJS » Sun, 18 Jan 2009 00:32:29 GMT

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



Similar Threads:

1.How can I import addresses in Excel over to address labels in

2.Changing name/address in Excel row to Word address block format

Hello,

I have a row in Excel where each cell has a first name, last name, address, 
city, state and zip code. I don't need to copy all of the cells in this row; 
just the cells I listed above.
I want to be able to copy those cells, paste it in Word and format it so it 
looks like an address block at the beginning of a letter, ex:

John Smith
123 Apple St.
St. Louis, MO 98765

These different address blocks will be added to letters that already exist. 
I just have to add the address blocks to them. 
I tried pasting the cells from Excel to Word, converting table to text, then 
replacing the tab markers to paragraph markers but the paragraph marks didn't 
shift my address underneath my names or my city/state/zips under my addresses.

Please help. I have hundreds of letters to do and don't relish having to 
manually add the address info in Excel to these different letters in Word.

Thank you!!
Studebaker

3.Changing name/address in Excel row to Word address block forma

4.import email address from excel..

5.Editing IP address in Excel ODBC link

6. Building Email addresses in Excel...

7. Email Addresses on Excel

8. Copy email addresses from excel to windows mail



Return to MS OFFICE OUTLOOK

 

Who is online

Users browsing this forum: No registered users and 4 guest