Exporting a named range in Excel to Outlook folder. Part 2

[Guest]

Karl, Please take a look...for some reason...i could not reply to your last post within the thread. So here is a continuation of my postings that started on 7/11 and were titled "Exporting a range of cells in Excel to Outlook 2003"

Reply to your last posting :
Ok Karl...progress has been made! But...success is still beyond me. I can't believe such a simple thing has been so difficult. First I want to say thank you.

Next I need you to clarify some things that i see as a possible errors in your directions. More likely not. LOL

You mention that i can enter the column name in the header row. Done. For column A i have set a column name: "Login" in cell A1. But you then say I can define a second name in cell A2 that will define the name for the information placed in row B. This is where i am confused. You say that by doing this I would have cell data ranging from A1 to B101. Karl, I would have cell data ranging from A1-A102! in Row A. This is because I have names in both A1 and A2 and have records 1-100 beginning in A3 and ranging to A102. In row B with no column name--the records( i named the second row "EmailAdds and placed in A2 per your directions)-- would be ranging from B1 to B100.

This is contrary to your directions.

So...i decided to try it this way: I placed a column name for each row in cell 1 of each row. So now Row A has the column name "Login" in cell A1 and Row B has a column name "EmailAdds" in B1. I assigned a named range for each row so I can keep this simple. The named range for A1-101 is "loginnames" and the named range for cells B1-101 is "memberemails".

Now when I close the file and open outlook I choose to import a named range. I choose "loginnames" as the named range to import. I now see the actual column name "Login" instead of the records! Progress! BUT...dragging this to any <Name> field does not allow for further action as the OK option STILL greyed out. I cancel. I have no other choice. I choose finish when closing the window and once agin have 100 empty records imported into my target folder.

What the *#%@????

 

[Karl Timmermans]

Just a few quick things:

- One row = information related to ONE contact regardless of how many pieces
(fields) of information you have for that contact.

- One column = one field (one piece of information for a given contact in a
row) in Excel this would mean references to cells $A$1-$IV$1 (for sake of
simplicity - max of 255 columns per row)

- Header names = column names (first ROW contains a name for each column
(field) in all following rows)

- A NAMED RANGE is not a column or row name - it is a reference to a
complete body of information that you want to work with (or in this case -
import) so if the column(s) in your first row contains the column/field
names - and you had 100 rows of data - your NAMED RANGE would be for A1-A101
or A1-B101 (last entry simply depends on how many columns you are
using.etc). For importing purposes it would NEVER refer to a single cell and
I can ever see it refering only to a single row.

To summarize - all the information related to a SINGLE contact MUST BE
contained in a SINGLE row and the columns identifiy the pieces of
information related to that single contact(i.e. name, address, emailaddr,
phone, etc etc etc etc). If your data is not constructed in that fashion,
you won't be able to do anything with it in terms of importing - Excel or
otherwise.

Karl

Karl, Please take a look...for some reason...i could not reply to your

last post within the thread. So here is a continuation of my postings that
started on 7/11 and were titled "Exporting a range of cells in Excel to
Outlook 2003"

Reply to your last posting :
Ok Karl...progress has been made! But...success is still beyond me. I

can't believe such a simple thing has been so difficult. First I want to say
thank you.

Next I need you to clarify some things that i see as a possible errors in

your directions. More likely not. LOL

You mention that i can enter the column name in the header row. Done. For

column A i have set a column name: "Login" in cell A1. But you then say I
can define a second name in cell A2 that will define the name for the
information placed in row B. This is where i am confused. You say that by
doing this I would have cell data ranging from A1 to B101. Karl, I would
have cell data ranging from A1-A102! in Row A. This is because I have names
in both A1 and A2 and have records 1-100 beginning in A3 and ranging to
A102. In row B with no column name--the records( i named the second row
"EmailAdds and placed in A2 per your directions)-- would be ranging from B1
to B100.

This is contrary to your directions.

So...i decided to try it this way: I placed a column name for each row in

cell 1 of each row. So now Row A has the column name "Login" in cell A1 and
Row B has a column name "EmailAdds" in B1. I assigned a named range for each
row so I can keep this simple. The named range for A1-101 is "loginnames"
and the named range for cells B1-101 is "memberemails".

Now when I close the file and open outlook I choose to import a named

range. I choose "loginnames" as the named range to import. I now see the
actual column name "Login" instead of the records! Progress! BUT...dragging
this to any <Name> field does not allow for further action as the OK option
STILL greyed out. I cancel. I have no other choice. I choose finish when
closing the window and once agin have 100 empty records imported into my
target folder.

 

[Sue Mosher [MVP-Outlook]]

And it would refer to a single column only if each data record being
imported has only one data field, which is highly unlikely.