A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Import contacts from Excel



 
 
Thread Tools Display Modes
  #1  
Old March 22nd, 2010, 02:29 PM posted to microsoft.public.outlook.contacts
angie
external usenet poster
 
Posts: 314
Default Import contacts from Excel

I have numerous contact lists with various categories and wondered if i can
import them into an email distribution list so that i do not need to hand
type each email?
thanks
  #2  
Old March 22nd, 2010, 04:01 PM posted to microsoft.public.outlook.contacts
Brian Tillman [MVP-Outlook]
external usenet poster
 
Posts: 2,485
Default Import contacts from Excel

"angie" wrote in message
...

I have numerous contact lists with various categories and wondered if i can
import them into an email distribution list so that i do not need to hand
type each email?


You can't import into a DL. Instead import into your Contacts and assign
categories to the imported contacts. See this:
http://www.slipstick.com/contacts/dl.asp#olcontacts

If you MUST use a DL, you can create the DLs like this:
http://www.outlook-tips.net/archives/2004/20041105.htm
--
Brian Tillman [MVP-Outlook]

  #3  
Old March 22nd, 2010, 04:50 PM posted to microsoft.public.outlook.contacts
angie
external usenet poster
 
Posts: 314
Default Import contacts from Excel

I tried importing from excel but i get an error about "ranges" . should the
criteria be under a particular range name (ie. First name versus First,etc...)

thanks

"Brian Tillman [MVP-Outlook]" wrote:

"angie" wrote in message
...

I have numerous contact lists with various categories and wondered if i can
import them into an email distribution list so that i do not need to hand
type each email?


You can't import into a DL. Instead import into your Contacts and assign
categories to the imported contacts. See this:
http://www.slipstick.com/contacts/dl.asp#olcontacts

If you MUST use a DL, you can create the DLs like this:
http://www.outlook-tips.net/archives/2004/20041105.htm
--
Brian Tillman [MVP-Outlook]

.

  #4  
Old March 22nd, 2010, 05:02 PM posted to microsoft.public.outlook.contacts
Gordon[_13_]
external usenet poster
 
Posts: 3,406
Default Import contacts from Excel


"angie" wrote in message
...
I tried importing from excel but i get an error about "ranges" . should
the
criteria be under a particular range name (ie. First name versus
First,etc...)


You need to assign a name to the data range. If you don't know how to do
this, save the Excel file as a csv and import that.

  #5  
Old March 22nd, 2010, 07:03 PM posted to microsoft.public.outlook.contacts
angie
external usenet poster
 
Posts: 314
Default Import contacts from Excel

thank you for your help!!

"Gordon" wrote:


"angie" wrote in message
...
I tried importing from excel but i get an error about "ranges" . should
the
criteria be under a particular range name (ie. First name versus
First,etc...)


You need to assign a name to the data range. If you don't know how to do
this, save the Excel file as a csv and import that.

.

  #6  
Old March 22nd, 2010, 08:02 PM posted to microsoft.public.outlook.contacts
Gordon[_13_]
external usenet poster
 
Posts: 3,406
Default Import contacts from Excel


"angie" wrote in message
...
thank you for your help!!


YW!

 




Thread Tools
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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.