| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export names and address into outlook
I am trying into import from outlook a data base that is in Excel...error
pops up stating that there is "no named ranges" any ideas or suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export names and address into outlook
Yes.
Select the range that has the names and addresses including headers and InsertName?Define. Give it a name like MyName Save then try again. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 14:21:00 -0800, Toby wrote: I am trying into import from outlook a data base that is in Excel...error pops up stating that there is "no named ranges" any ideas or suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export names and address into outlook
when I select the row with the headings on it....do I rename in the fx box?
"Gord Dibben" wrote: Yes. Select the range that has the names and addresses including headers and InsertName?Define. Give it a name like MyName Save then try again. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 14:21:00 -0800, Toby wrote: I am trying into import from outlook a data base that is in Excel...error pops up stating that there is "no named ranges" any ideas or suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export names and address into outlook
By headers I mean you have at least 2 columns with titles like Name Address
and the data in rows below these. Select the title cells and those below with the data. Assume A1:B4 looks like this............. Name Address Gord 123 main st. Toby 456 second sr. Bert 789 third st. Select A1:B4 and InsertNameDefine. BTW........nothing is done in the fx box........fx is the Function Wizard Gord On Wed, 21 Nov 2007 15:13:01 -0800, Toby wrote: when I select the row with the headings on it....do I rename in the fx box? "Gord Dibben" wrote: Yes. Select the range that has the names and addresses including headers and InsertName?Define. Give it a name like MyName Save then try again. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 14:21:00 -0800, Toby wrote: I am trying into import from outlook a data base that is in Excel...error pops up stating that there is "no named ranges" any ideas or suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i export from excel to outlook | Excel Discussion (Misc queries) | |||
| Export dates from excel into outlook? | Excel Discussion (Misc queries) | |||
| export from Outlook to Excel | Setting up and Configuration of Excel | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| How do i export a Excel database a Outlook address book? | Excel Discussion (Misc queries) | |||
Linear Mode
