| Author |
Export from Excel to Outlook
|
|
| well0120 2002-09-03, 3:28 pm |
| Dear friends,
Here I am with yet another question. This time it has to do with exporting data from Excel to Outlook.
Here's the deal. I had been trying to extract the contacts from a third party Real Estate software, and after hours trying to figure out this software I finally manged to export all the contacts to Excel. It looked horrible at first, but after some formatting it gained some decent shape.
Now the trick is to get this contact list to be exported to Outlook. Everytime I try I get this error message saying that there is a problem with "name range". I don't know what to make of this, because I already have all the fields defined just like the ones in Outlook (e.g. First Name, Last Name, etc).
I've seen this done before so I know it's possible. The question is how?!!
If any of you guys and gals out there know anything about that I will really appreciate the help. Thanks a lot! | |
| Paisleyskye 2002-09-03, 3:41 pm |
| I think all you need to do is to give the range of cells you want to copy a name, and then import into Outlook instead of exporting from Excel.
The range is more or less a group of cells. In order to export Excel data into Outlook you need to select the range of cells you want to export, and then click on the Name box (should be at the left of the formula bar), give the range a name which you will type into the Name box, and then press Enter on your keyboard.
After that you need to close the Excel workbook and import the information through Microsoft Outlook.
Let me know if this is what you needed. | |
|
| Just some thoughts...
Have you defined a Named Range in your Excel spreadsheet? Remember the name assigned to the range cannot be the same as one of the column header names.
Maybe this will fly for you:
-Open up your spreadsheet in Excel
-Select the range of information you want to import.
-Click on Insert | Name, and then click Define.
-In the Names In Workbook box, type a name for the range and then click Add. The name cannot contain spaces, and it cannot be the same as the name of a column header.
-Click OK.
-Save the spreadsheet and try the import into Outlook again.
If this doesn't work for you, then I'm not sure what the problem is.
Hope this helps some  | |
| Paisleyskye 2002-09-03, 3:52 pm |
| Sounds like you and I were thinking of the same solution pretty much - we just had different methods of getting to the ultimate solution. | |
|
| quote:
Originally posted by Paisleyskye
Sounds like you and I were thinking of the same solution pretty much - we just had different methods of getting to the ultimate solution.
Yup, that's what I thought as well.
You type faster too.  | |
| Paisleyskye 2002-09-03, 4:12 pm |
| LOL! That's probably only because I have to type all the time. I bet if I quit typing for a month my speed would decrease dramatically. | |
| well0120 2002-09-03, 9:21 pm |
| Damn, you guys are good!!!! That should work like a charm. Kudos to Spid and Paisleyskye
for the great input.
Cheers!
quote:
Originally posted by Spid
Just some thoughts...
Have you defined a Named Range in your Excel spreadsheet? Remember the name assigned to the range cannot be the same as one of the column header names.
Maybe this will fly for you:
-Open up your spreadsheet in Excel
-Select the range of information you want to import.
-Click on Insert | Name, and then click Define.
-In the Names In Workbook box, type a name for the range and then click Add. The name cannot contain spaces, and it cannot be the same as the name of a column header.
-Click OK.
-Save the spreadsheet and try the import into Outlook again.
If this doesn't work for you, then I'm not sure what the problem is.
Hope this helps some
| |
| Noel Stalker 2004-08-28, 11:44 am |
| Hello all,
This is a really old post that I am responding to but it was the first thing that came up at "ask.com" when I punched in "how do i exportfrom excel to outlook". I have followed all of the steps, naming a range and then importing it into Outlook. Everything appears to work properly, my paperclip office assistant turns into a checkmark and I hear a pleasant confirmation beep. But then when I look into my contacts folder, the new contact is not there. Am I missing something? Thanks!
Noel Stalker | |
| curiousgeorge 2004-08-28, 2:52 pm |
| Have you tried saviing your Excel file as a CSV file, then import it into Outlook that way.
That's how I usually do it. | |
| Noel Stalker 2004-09-06, 5:22 pm |
| I found what I was doing wrong. I had to have the first row with the field names included in my named value.
Thanks for the suggestion though
Sincerely,
Noel Stalker
www.bethstalker.com | |
| fallen3345 2004-11-23, 10:11 pm |
| Help,
I am having the same problem. I need help! I have tried almost everything that I can think of.
Fallen... |
|
|
|