Diane
Wed Jul 30 22:43:44 PDT 2008
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/
Outlook Tips by email:
dailytips-subscribe-request@lists.outlooktips.net
EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:
http://www.slipstick.com
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" <alanbarlee@discussions.microsoft.com> wrote in message
news:7A475608-546E-4DBE-9240-513B60DB9B5A@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
>
> "alanbarlee" wrote:
>
>> 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
>>
>> "Diane Poremsky [MVP]" wrote:
>>
>> > 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/
>> >
>> > Outlook Tips by email:
>> > dailytips-subscribe-request@lists.outlooktips.net
>> >
>> > EMO - a weekly newsletter about Outlook and Exchange:
>> > EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>> >
>> > Outlook Tips:
http://www.outlook-tips.net/
>> > Outlook & Exchange Solutions Center:
http://www.slipstick.com
>> >
>> > 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" <alanbarlee@discussions.microsoft.com> wrote in message
>> > news:EDF9400B-A827-4705-A16E-100BDFA17338@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)
>> >
>> >