Importing Excel in Outlook 2007

[Ron]

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

Ron

 

[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!

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q

 

[Diane Poremsky [MVP]]

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.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

 

[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

 

[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

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.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

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

Ron

 

[Diane Poremsky [MVP]]

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

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

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

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.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

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

Ron

 

[Ron]

Diane,

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

Ron

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

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

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

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.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

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

Ron

 

[Brian Tillman [MVP - Outlook]]

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.