Dian I found the field nest to the address bar in excell but I am not sure of
what to name it . I am working with a customer list that I composed in excell
to allow me to set up mailers & keep track of their address,dob etc I need it
in out look so I can sink my new ipack so I dont have to enter all this data
buy hand. In out look it says that you can import the data but it will not as
it comes up with " the microsoft file .......................................
has nonamed ranges of tha data you want to import". I found where you want me
to be in excell but I am not sure of what to do. Thge office assent is
pointing me to make them a "cell: but then it gose to a window that
states:Info_type & a fill in space next to it & under that it says refence &
a fill in space next to that. this all seems to be trying to make a equations
of some type. I have the frist row of cells named ( like the title of what
the colums have in them) Last name,1st Name,Spouse
Name,Title,Company,Home#.Work#, Fax#,Email Address,Mailing Address,City,
State,Zip,etc......I have used this excell sptead sheet many times for fill
in on word like a mailing envlope ( as in mail merge) & it always asks me if
their is a header line to indocate the Name or title of the colum. I am sorry
I am not that trained on excell & I relize that excell is a great program &
has lots of capiblilty like forming cauclations or values but I have never
learned how to use these functions. I realy need to learn this stuff as it
would help me greatly. I know this is alot to ask but could you please help
me so I can import this list so I dont have to hand type it all in. I have
susfully imported this list befor into other programs like access & when I
was using Palm for my pda but my palm bit it & I cant hot sink it any more &
I wone this hp ipack & it is windows based & I realy like that as I can see
that it will sute me much better. I feel that this is somethig I can do as
far as the fixing the excell spread sheet but I am leary of trying to name
this & messing it up.
Thank you
David.
Diane Poremsky said:
Shoot... I see I mistyped - yes, do it in Excel, not outlook.
you need to name the range in EXCEL.
--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Join OneNote Tips mailing list:
http://www.onenote-tips.net/
david said:
Diane thank you for your response I will try what you are saying. I just
wanted to make sure you were talking about doing this in excell not
outlook.
Thanks a million & I will let you know if this wirks.
David
Diane Poremsky said:
you need to name the range in outlook. Select the cells that contain the
data and type a name into the field on the left of the address bar that
usually lists the select cell. see excel help for more information.
--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Join OneNote Tips mailing list:
http://www.onenote-tips.net/
I am trying to import a data base that I have in excell into my outlook
program via the import & export wizard. I get a message of the microft
excell
file .................has no named ranges. Use Microft excell to name
the
range of the data you want to import. Please if you know what to do I
could
use some help please
I only have books on Outlook, OneNote and Word available.