Hi all,



I need to import literally 3000 contacts into Outlook. I need to do this for
a survey I am conducting for my academic thesis (so, this is not a business
problem, and I don't have much money to spend :-(. I am going to mail these
companies and am going to send them a questionairre; therefore I need to
have these records in Outlook.



I want to do this via Excel (since importing it directly into Outlook is not
possible due to the list format). Unfortunately, the list (in plain text)
looks like the list on the bottom of my message (small example). (The list
is Excel is in 2 columns, but copy and paste did not work that well in this
message).



So, I now have two problems:

[1] The data does seem to be in standard databaseformat, although the fields
are not next to each other (from left to right) but below and above each
other, as well in two rows.

[2] Not allways are all fields filled: for example, sometimes the email
address is not filled in, or the fax is missing.



Thus, I can not assign headers to

it (in Outlook), and thus I can not map the fields during the import into

Outlook. I know I can use "transpose" in Excel to change rows into columns,

but this still requires a lot of manual work: I have to select each block,

Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not happy to

do so, since it may cause the RSI-problems very easily. So, could anybody

recommend a solution to my problem? I would really, really, really (and I
really mean really) appreciate this (!).



Thanks a lot,



Kind regards,



Jos









[Example of the list]



Abilita AG

Althardstrasse 80 Phone: 01/8427400

8105 Regensdorf Email:

Switzerland URL: http://www.abilita.ch/



(Explanation due to a wrong copy and paste in this message: Column 1 has 4
rows: Abilita AG, Althardstrasse 80, 8105 Regensdorf, Switzerland. Column 2
(to the right of column 1) has 3 fields: Phone, email, URL. In the next
address, below, the same goes, however, here the fax has been filled (as
opposed to the first record (Abilita))







AC-Service (Schweiz) AG

Hardstrasse 73 Phone: 056/437 41 11

5430 Wettingen Fax: 056/426 71 47

Switzerland Email:

URL: http://www.ac-service.com/



Acag Andres Consulting AG

Blue Max Gewerbezentrum Phone: 01/922 90 90

8708 Männedorf Fax: 01/922 90 99

Switzerland Email:

URL: http://www.acag.ch/