Addresses from Excel
by 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
by 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
by 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
by 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
by 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