importing Excel to Outlook

importing Excel to Outlook - NAMES RANGES??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lewisma9 - 26 Feb 2007 14:48 GMT

Hello:
I don't know Excel at all - but I need to import an Excel 2003 Address File
into Outlook 2003, and I'm having a problem: When I try to import it, I get
the Error Message that the Excel file doesn't have any "named ranges" - and
that I should go back into Excel to create a Named Range. How do I do this?
I am a complete novice with Excel.

I use Windows XP SP2 on a Compaq Presario V2000 laptop. Thanks!

Signature

lewisma9

Reply to this Message

JE McGimpsey - 26 Feb 2007 17:10 GMT

> I don't know Excel at all - but I need to import an Excel 2003 Address File
> into Outlook 2003, and I'm having a problem: When I try to import it, I get
[quoted text clipped - 3 lines]
>
> I use Windows XP SP2 on a Compaq Presario V2000 laptop. Thanks!

You've posted in a Macintosh Excel newsgroup. MacOffice doesn't include
Outlook, so I don't know whether anyone will be able to give a
definitive answer (you could try one of non-Mac XL groups or an Outlook
group).

However, creating a named range is easy. Select your range:

-click on the top left cell
-shift-click on the bottom-right cell

then enter the name in the Name box at the left side of the Formula Bar.

Reply to this Message

lewisma9 - 26 Feb 2007 18:01 GMT

Thank you JE, this is exactly with I need! But I have another really dumb
question: After I follow your steps, how do I SAVE the file? Right now,
when I type the new name in the NAME box, it disappears when I SAVE the file.
How do I get the name to stick? Thanks.

Signature

lewisma9

> > I don't know Excel at all - but I need to import an Excel 2003 Address File
> > into Outlook 2003, and I'm having a problem: When I try to import it, I get
[quoted text clipped - 15 lines]
>
> then enter the name in the Name box at the left side of the Formula Bar.

Reply to this Message

Bob Greenblatt - 26 Feb 2007 18:06 GMT

On 2/26/07 1:01 PM, in article
33FF0A9E-DF7D-4B4D-BDC4-137673B36457@microsoft.com, "lewisma9"

> Thank you JE, this is exactly with I need! But I have another really dumb
> question: After I follow your steps, how do I SAVE the file? Right now,
> when I type the new name in the NAME box, it disappears when I SAVE the file.
> How do I get the name to stick? Thanks.

PMFJI,

You need to choose File-Save As to change the name. while you are at it,
save the file in Tab delimited text format and it will probably import
directly into outlook. No need for named ranges.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / February 2007

importing Excel to Outlook - NAMES RANGES??