|
| 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. |
|
|||||||
| Tags: addresses, excel, import, outlook, spreadsheet |
|
|
Thread Tools | Display Modes |
|
#1
March 6th 07, 02:42 PM
posted to microsoft.public.outlook
|
|||
|
|||
How do I import addresses from an Excel Spreadsheet into Outlook?
Please can someone help with this?
I have named the ranges in Excel, but after I have mapped everything, and try to import, all the fields from Excel end up as separate entries. What have I done wrong? Neil 
|
| Ads |
|
#2
March 6th 07, 03:20 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
How do I import addresses from an Excel Spreadsheet into Outlook?
"ranges"? For an import, you need only one named range that covers all the data you want to import.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Neil" wrote in message news  Please can someone help with this? I have named the ranges in Excel, but after I have mapped everything, and try to import, all the fields from Excel end up as separate entries. What have I done wrong? Neil
|
|
#3
March 6th 07, 05:21 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
How do I import addresses from an Excel Spreadsheet into Outlook?
Thanks for the response, which range do I name?
Neil On Tue, 6 Mar 2007 10:20:52 -0500, "Sue Mosher [MVP-Outlook]" wrote: "ranges"? For an import, you need only one named range that covers all the data you want to import.
|
|
#4
March 6th 07, 05:54 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
How do I import addresses from an Excel Spreadsheet into Outlook?
Neil wrote:
Thanks for the response, which range do I name? Neil On Tue, 6 Mar 2007 10:20:52 -0500, "Sue Mosher [MVP-Outlook]" wrote: "ranges"? For an import, you need only one named range that covers all the data you want to import. make all the data into one named range, with NO gaps between columns or rows....
|
|
#5
March 6th 07, 11:16 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
How do I import addresses from an Excel Spreadsheet into Outlook?
As I said before, the only range you need is one that covers all the data you want to import. Include the column heading row as well, if the worksheet has one.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Neil" wrote in message ... Thanks for the response, which range do I name? Neil On Tue, 6 Mar 2007 10:20:52 -0500, "Sue Mosher [MVP-Outlook]" wrote: "ranges"? For an import, you need only one named range that covers all the data you want to import.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using email addresses from an Excel spreadsheet? | Jan | Outlook Express | 3 | October 4th 06 01:37 PM |
| How do I import contact info from an excel spreadsheet to outlook | CLF8475 | Outlook - Using Contacts | 2 | September 8th 06 02:31 AM |
| Import contacts from excel spreadsheet | Sharon @ Flag Fen | Outlook - Using Contacts | 1 | May 9th 06 01:35 PM |
| Importing addresses from an Excel spreadsheet | pddmcse | Outlook - Using Contacts | 1 | April 27th 06 08:17 AM |
| import excel spreadsheet names emails addresses to distribution l | Mary | Outlook - Using Contacts | 1 | January 16th 06 08:26 PM |
Linear Mode
