Excel 07 xls contact records imported by Outlook 2007 displaced

[alanbarlee]

Hi!
I have a table of contact data in Excel 2007 (saved in 2003 xls format),
with named fields, which imports into a new 'Contacts' folder in Outlook 2007
but with each block of records in the several 'Contacts' fields appearing
vertically displaced, each just below the other (as though there were
'invisible' records above them - but selecting and deleting the entire
contacts folder 'records' prior to import does not help, nor does a cut
-and-paste of the offending records up to their correct rows).

Any ideas out there on how I should prepare the Excel or Outlook files so
this doesn't happen?
Many thanks, Alan (Australia)

 

[Diane Poremsky [MVP]]

It sounds like the problem is in Excel - the records need to be one row per
contact.

I'm guessing some cells are merged. Try this: select the entire worksheet
by clicking on the corner where A and 1 come together. Right click and
choose Format cells, alignment tab. Is the merge cells box clear? If not,
you'll need to edit each merged cell and un-merge them.

If there are no merged cells, go down the rows of records, selecting each
record and verifying all of the data for the record is in a single row. If
not, you'll need to move the data and delete the extra row.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[alanbarlee]

Hi Diane - and many thanks for responding.

I double-checked for merged cells, empty or inconsistent row data and
formats, and also for any error messages in my Excel file, but it all seems
to be clean.

Another hopeful clue follows.

When mapping the named Excel columns to the (customised) Outlook fields, the
second record appears against each mapped field, rather than the (named)
column names. If I add a blank row above the row of column names (i.e.outside
the table), then the first record appears during mapping.

Another anomaly is that when an Excel cell (not row) is devoid of data, the
mapping shows 'F1' in each case, which is an empty cell above a column name.

This is weird - and frustrating! Any further thoughts?

Regards,

Alan

It sounds like the problem is in Excel - the records need to be one row per
contact.

I'm guessing some cells are merged. Try this: select the entire worksheet
by clicking on the corner where A and 1 come together. Right click and
choose Format cells, alignment tab. Is the merge cells box clear? If not,
you'll need to edit each merged cell and un-merge them.

If there are no merged cells, go down the rows of records, selecting each
record and verifying all of the data for the record is in a single row. If
not, you'll need to move the data and delete the extra row.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Hi!
I have a table of contact data in Excel 2007 (saved in 2003 xls format),
with named fields, which imports into a new 'Contacts' folder in Outlook
2007
but with each block of records in the several 'Contacts' fields appearing
vertically displaced, each just below the other (as though there were
'invisible' records above them - but selecting and deleting the entire
contacts folder 'records' prior to import does not help, nor does a cut
-and-paste of the offending records up to their correct rows).

Any ideas out there on how I should prepare the Excel or Outlook files so
this doesn't happen?
Many thanks, Alan (Australia)

 

[alanbarlee]

Sorry Diane - a correction to my last post (below):-

Itis the first (not the second) Excel record that appear in Outlook
aftermapping. (Ignore the next sentence, referring to an inserted row outside
the Excel table). I can't get the mapping to refer to the named Excel fields,
including when a cell is devoid of data. (The field naming was done via
simultaneous selection of the required group of column headings, which show
in the Names Manager list, but not in the Names Box).

I tried a shortened Excel table containing only five records, but the
problem of vertical displacement of the fields persists.

Weird, huh!

Alan

Hi Diane - and many thanks for responding.

I double-checked for merged cells, empty or inconsistent row data and
formats, and also for any error messages in my Excel file, but it all seems
to be clean.

Another hopeful clue follows.

When mapping the named Excel columns to the (customised) Outlook fields, the
second record appears against each mapped field, rather than the (named)
column names. If I add a blank row above the row of column names (i.e.outside
the table), then the first record appears during mapping.

Another anomaly is that when an Excel cell (not row) is devoid of data, the
mapping shows 'F1' in each case, which is an empty cell above a column name.

This is weird - and frustrating! Any further thoughts?

Regards,

Alan

It sounds like the problem is in Excel - the records need to be one row per
contact.

I'm guessing some cells are merged. Try this: select the entire worksheet
by clicking on the corner where A and 1 come together. Right click and
choose Format cells, alignment tab. Is the merge cells box clear? If not,
you'll need to edit each merged cell and un-merge them.

If there are no merged cells, go down the rows of records, selecting each
record and verifying all of the data for the record is in a single row. If
not, you'll need to move the data and delete the extra row.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Hi!
I have a table of contact data in Excel 2007 (saved in 2003 xls format),
with named fields, which imports into a new 'Contacts' folder in Outlook
2007
but with each block of records in the several 'Contacts' fields appearing
vertically displaced, each just below the other (as though there were
'invisible' records above them - but selecting and deleting the entire
contacts folder 'records' prior to import does not help, nor does a cut
-and-paste of the offending records up to their correct rows).

Any ideas out there on how I should prepare the Excel or Outlook files so
this doesn't happen?
Many thanks, Alan (Australia)

 

[Diane Poremsky [MVP]]

if you don't mind me seeing the data, please send the workbook to my email
address and I'll take a look at it.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Sorry Diane - a correction to my last post (below):-

Itis the first (not the second) Excel record that appear in Outlook
aftermapping. (Ignore the next sentence, referring to an inserted row
outside
the Excel table). I can't get the mapping to refer to the named Excel
fields,
including when a cell is devoid of data. (The field naming was done via
simultaneous selection of the required group of column headings, which
show
in the Names Manager list, but not in the Names Box).

I tried a shortened Excel table containing only five records, but the
problem of vertical displacement of the fields persists.

Weird, huh!

Alan

Hi Diane - and many thanks for responding.

I double-checked for merged cells, empty or inconsistent row data and
formats, and also for any error messages in my Excel file, but it all
seems
to be clean.

Another hopeful clue follows.

When mapping the named Excel columns to the (customised) Outlook fields,
the
second record appears against each mapped field, rather than the (named)
column names. If I add a blank row above the row of column names
(i.e.outside
the table), then the first record appears during mapping.

Another anomaly is that when an Excel cell (not row) is devoid of data,
the
mapping shows 'F1' in each case, which is an empty cell above a column
name.

This is weird - and frustrating! Any further thoughts?

Regards,

Alan

It sounds like the problem is in Excel - the records need to be one row
per
contact.

I'm guessing some cells are merged. Try this: select the entire
worksheet
by clicking on the corner where A and 1 come together. Right click and
choose Format cells, alignment tab. Is the merge cells box clear? If
not,
you'll need to edit each merged cell and un-merge them.

If there are no merged cells, go down the rows of records, selecting
each
record and verifying all of the data for the record is in a single row.
If
not, you'll need to move the data and delete the extra row.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Hi!
I have a table of contact data in Excel 2007 (saved in 2003 xls
format),
with named fields, which imports into a new 'Contacts' folder in
Outlook
2007
but with each block of records in the several 'Contacts' fields
appearing
vertically displaced, each just below the other (as though there were
'invisible' records above them - but selecting and deleting the
entire
contacts folder 'records' prior to import does not help, nor does a
cut
-and-paste of the offending records up to their correct rows).

Any ideas out there on how I should prepare the Excel or Outlook
files so
this doesn't happen?
Many thanks, Alan (Australia)