Importing Excel in Outlook 2007

  • Thread starter Ron
  • Start date Views 1,588
Status
Not open for further replies.
R

Ron

I believe I am doing everything correct with the wizard, but nothing seem to

end up in the contact. Any idea?

Ron
 
B

Ben M. Schorr - MVP

You'll need to tell us exactly what you're trying to do and exactly what

steps you've already taken if you want any kind of specific assistance.

Thanks!





"Ron" <Ron> wrote in message

news:EBF35F3E-63D1-43F1-B99A-2CFF4746585B@microsoft.com:


> I believe I am doing everything correct with the wizard, but nothing seem to
> end up in the contact. Any idea?

> Ron
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
lack of a named range is often the cause - see

http://www.slipstick.com/Tutorials/import/import.htm for the steps required

to import from excel.



"Ron" <Ron> wrote in message

news:EBF35F3E-63D1-43F1-B99A-2CFF4746585B@microsoft.com...
> I believe I am doing everything correct with the wizard, but nothing seem
> to
> end up in the contact. Any idea?

> Ron
>
 
R

Ron

Ben,

I have exported contracts from Goldmine to an Excel file. Now I am trying

to import them into Outlook 2007, which I have just installed. I go to

Import and Export from the File menu. Click on Import From Another Program

or File, select Microsoft Excel 97-2003, browse and select my Excel file.

Then select Contracts as the destination folder, select Map Custom Fields as

all the names don't match. Drag the names over to the appropriate fields,

click OK and Finish. The program seems to run for a bit, but nothing appears

in the Contacts.

Ron

"Ben M. Schorr - MVP" wrote:


> You'll need to tell us exactly what you're trying to do and exactly what
> steps you've already taken if you want any kind of specific assistance.

> Thanks!

> >
>

>

> "Ron" <Ron> wrote in message
> news:EBF35F3E-63D1-43F1-B99A-2CFF4746585B@microsoft.com:
>
> > I believe I am doing everything correct with the wizard, but nothing seem to
> > end up in the contact. Any idea?
> > Ron


>
 
R

Ron

Diane,

The first time I was missing some fields in the Map Custom Fields section of

the Wizard and I needed to change the named range to see them. I can see and

map all fields now, but nothing is getting imported into Contacts even though

it seems to run for a bit.

Thanks,

Ron

"Diane Poremsky [MVP]" wrote:


> lack of a named range is often the cause - see
> http://www.slipstick.com/Tutorials/import/import.htm for the steps required
> to import from excel.

> >

>

>

>

> "Ron" <Ron> wrote in message
> news:EBF35F3E-63D1-43F1-B99A-2CFF4746585B@microsoft.com...
> > I believe I am doing everything correct with the wizard, but nothing seem
> > to
> > end up in the contact. Any idea?
> > Ron
> >

>
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Check the named range in Excel - does it include all of the records?



"Ron" <Ron> wrote in message

news:7F03A3A0-CE42-4BB7-B287-FB1A21B20E22@microsoft.com...
> Diane,

> The first time I was missing some fields in the Map Custom Fields section
> of
> the Wizard and I needed to change the named range to see them. I can see
> and
> map all fields now, but nothing is getting imported into Contacts even
> though
> it seems to run for a bit.

> Thanks,

> Ron

> "Diane Poremsky [MVP]" wrote:
>
> > lack of a named range is often the cause - see
> > http://www.slipstick.com/Tutorials/import/import.htm for the steps
> > required
> > to import from excel.
>

>> > >

>

>
>
>>

>

>>

>

>>
>

>> "Ron" <Ron> wrote in message
> > news:EBF35F3E-63D1-43F1-B99A-2CFF4746585B@microsoft.com...
> > > I believe I am doing everything correct with the wizard, but nothing
> > > seem
> > > to
> > > end up in the contact. Any idea?
> >> > Ron
> > >

> >
 
R

Ron

Diane,

That was my problem. I am not used to 2007 yet. Thanks,

Ron

"Diane Poremsky [MVP]" wrote:


> Check the named range in Excel - does it include all of the records?

> >

>

>

>

> "Ron" <Ron> wrote in message
> news:7F03A3A0-CE42-4BB7-B287-FB1A21B20E22@microsoft.com...
> > Diane,
> > The first time I was missing some fields in the Map Custom Fields section
> > of
> > the Wizard and I needed to change the named range to see them. I can see
> > and
> > map all fields now, but nothing is getting imported into Contacts even
> > though
> > it seems to run for a bit.
> > Thanks,
> > Ron
> > "Diane Poremsky [MVP]" wrote:
> >
> >> lack of a named range is often the cause - see
> >> http://www.slipstick.com/Tutorials/import/import.htm for the steps
> >> required
> >> to import from excel.
> >
> >> > >>

> >
> >
> >
> >>

> > >
> >>

> > >
> > >>
> >
> >> "Ron" <Ron> wrote in message
> >> news:EBF35F3E-63D1-43F1-B99A-2CFF4746585B@microsoft.com...
> >> > I believe I am doing everything correct with the wizard, but nothing
> >> > seem
> >> > to
> >> > end up in the contact. Any idea?
> >> >> > Ron
> >> >>

>
 

Brian Tillman

Senior Member
"Ron" <Ron> wrote in message

news:027EF30C-B7C2-449A-A54B-80F1B13B2377@microsoft.com...


> That was my problem. I am not used to 2007 yet. Thanks,


That's not 2007-specific. All versions of Outlook require an appropriate

named range to import from a spreadsheet. Many people use a CSV file instead

because there are no named ranges for that type of file.

--
 
Status
Not open for further replies.

Similar threads

Top