Outlook importing each field as a separate record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel spreadsheet with all the columns the correct way (colum A all
names, column B all email addresses, etc), I have defined all the cell names
properly, etc.

The problem is, when I import my excel spreadsheet into Outlook, every cell
from my excel spreadsheet is its own record.

PLEASE HELP!!! What am I doing wrong?
 
LeeNeedsHelp said:
I have an excel spreadsheet with all the columns the correct way
(colum A all names, column B all email addresses, etc), I have
defined all the cell names properly, etc.

The problem is, when I import my excel spreadsheet into Outlook,
every cell from my excel spreadsheet is its own record.
Click to expand...

Are you creating a named range?
 
Yes....For every cell, I have associated it with a named range by selecting
on the file menu "Insert", "Name" and "Define". I then ensure that the
Refers To field includes the entire range of the column I am defining
(example: =worksheetname!$A$2:$A$100) and am doing that for every column that
I want to import into Outlook.

All other ideas you may have are greatly appreciated!
 
LeeNeedsHelp said:
Yes....For every cell, I have associated it with a named range by
selecting on the file menu "Insert", "Name" and "Define". I then
ensure that the Refers To field includes the entire range of the
column I am defining (example: =worksheetname!$A$2:$A$100) and am
doing that for every column that I want to import into Outlook.
Click to expand...

You need one named range that covers the entire set of data you want to
import.
 
Back
Top