 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / March 2005distribution list from excel
I am using Outlook 2003 and would like to create a distribution list by importing email addresses from an Excel spreadsheet. I have followed the directions for importing, but it won't work. I get a message that says it can't complete the import. Am I going about this incorrectly? thank you Probably. Since you failed to tell us what you are doing, it's rather hard for anyone to know.  SignatureRuss Valentine [MVP-Outlook] >I am using Outlook 2003 and would like to create a distribution list by > importing email addresses from an Excel spreadsheet. I have followed the > directions for importing, but it won't work. I get a message that says it > can't complete the import. Am I going about this incorrectly? > > thank you I followed the directions titled "Import contacts from Excel to Outlook" http://office.microsoft.com/en-us/assistance/HA010964231033.aspx Really don't want to tell us anything do you? That method works fine. We would have no way of knowing what you did wrong without your telling us what you did and what happened. This method will import into your Contacts. You cannot import directly into a DL. SignatureRuss Valentine [MVP-Outlook] >I followed the directions titled "Import contacts from Excel to Outlook" > http://office.microsoft.com/en-us/assistance/HA010964231033.aspx I am trying to create a distribution list by importing email addresses into Microsoft Outlook 2003. I have an Excel spreadsheet that has 154 email addresses listed in column A. Cell A1 is titled "email addresses". There is no other data in the spreadsheet. I follow the directions, step by step, exactly as described on the MS Office website sited earlier: http://office.microsoft.com/en-us/assistance/HA010964231033.aspx and try to import to either my contacts folder or to a sub folder of the contact folder. Each time, a window titled "Import and Export Progress" opens and the progress bar fills with green rectangles. After several seconds, a second window then opens that reads: "Microsoft Office Outlook has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost." Restart Microsoft Office Outlook is checked off. It also give me the option to send a report to Microsoft. I have restarted Microsoft Office Outlook and repeated the procedure several times. I have also repeated the entire procedure after restarting the computer. I have also tried repeating the procedure after closing all other programs on the computer. Computer has 512 MB RAM. > Really don't want to tell us anything do you? > That method works fine. We would have no way of knowing what you did wrong [quoted text clipped - 3 lines] > >I followed the directions titled "Import contacts from Excel to Outlook" > > http://office.microsoft.com/en-us/assistance/HA010964231033.aspx You mean you are trying to import a spreadsheet that has only one field? You would need a minimum of 2 fields to create a Contact Record: a name must be associated with an email address to create a Contact. SignatureRuss Valentine [MVP-Outlook] >I am trying to create a distribution list by importing email addresses into > Microsoft Outlook 2003. I have an Excel spreadsheet that has 154 email [quoted text clipped - 31 lines] >> >I followed the directions titled "Import contacts from Excel to Outlook" >> > http://office.microsoft.com/en-us/assistance/HA010964231033.aspx I did not realize I had to have more than one field. I do not have names, just email addresses (this is a business leads list). What do you suggest? Can I add a fake name? Can it be the same for each email address? Do I need first name and last name or is one name sufficient? Thank you. > You mean you are trying to import a spreadsheet that has only one field? > You would need a minimum of 2 fields to create a Contact Record: a name must [quoted text clipped - 34 lines] > >> >I followed the directions titled "Import contacts from Excel to Outlook" > >> > http://office.microsoft.com/en-us/assistance/HA010964231033.aspx If I were you I'd go a different route. DL's are not very robust or reliable anyway. Why not use a mail merge and just use your spreadsheet as a data source for the merge? SignatureRuss Valentine [MVP-Outlook] >I did not realize I had to have more than one field. I do not have names, > just email addresses (this is a business leads list). What do you suggest? [quoted text clipped - 51 lines] >> >> >Outlook" >> >> > http://office.microsoft.com/en-us/assistance/HA010964231033.aspx That sounds like a fine idea, but I can't find directions on how to do that..only directions for a merge for printed mailing. Can you point me in the right direction? Thank you > If I were you I'd go a different route. DL's are not very robust or reliable > anyway. [quoted text clipped - 55 lines] > >> >> >Outlook" > >> >> > http://office.microsoft.com/en-us/assistance/HA010964231033.aspx Outlook uses Word for performing mail merge functions such as email merges. For an overview of these functions take a look here: http://www.slipstick.com/contacts/printlabel.htm http://www.outlook-tips.net/howto/mailmerge.htm SignatureRuss Valentine [MVP-Outlook] > That sounds like a fine idea, but I can't find directions on how to do > that..only directions for a merge for printed mailing. Can you point me in [quoted text clipped - 73 lines] >> >> >> >Outlook" >> >> >> > http://office.microsoft.com/en-us/assistance/HA010964231033.aspx |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.