distribution list import into outlook07 - wrong syntax/structure

[[OUPA]MrNutz]

Hey peeps..

I've got to help a transporter import about 600 email addys from an xls (distribution list) file

The current file received looks like this:

name surname <[email protected]>,
name surname <[email protected]>,

Note that all of these info in each line is only in col A - nothing goes into next col ......also there are no headers at the top.

Any suggestions how i go about not manually have to convert each of the 600 addys

if i had some proper programming skills i would try on my own but i don't have any.

thanks

 

[Borrels]

No programming skills required... In Excel, use the Data > Text to Columns feature. Choose the Delimited by Spaces option.

When importing, make sure you add a heading row to the xls data, otherwise Outlook may not know which field your column data should go to.

 

[[OUPA]MrNutz]

Thanks for the help - the splitting of the fields worked nicely - first removed the < then the > and lastly the ,

Did add the names to the top of the column field but then found something strange.

Outlook did a semi-correct import of only the first two rows and then it stopped...there are no funny spaces/characters remaining in the xls file from them to the other data so i dunno....i've removed the first two rows of info , but then it doesn't import anything.....

There wasn't a problem with the mapping.. fields<>fields with the initial import attempt...... decided to define the data in the field to the name at the top - then it wants to import one-one instead of asking for a once off column name (field to associate with)....

Dunno

 

[Borrels]

Thanks for the help - the splitting of the fields worked nicely - first removed the < then the > and lastly the ,

Did add the names to the top of the column field but then found something strange.

Outlook did a semi-correct import of only the first two rows and then it stopped...there are no funny spaces/characters remaining in the xls file from them to the other data so i dunno....i've removed the first two rows of info , but then it doesn't import anything.....

There wasn't a problem with the mapping.. fields<>fields with the initial import attempt...... decided to define the data in the field to the name at the top - then it wants to import one-one instead of asking for a once off column name (field to associate with)....

Dunno

Hmmmm. Maybe apply the TRIM() function on all your columns before importing, in case there are spaces before the data that is confusing Outlook. Then also try saving it as a comma separated or tab separated text file and importing that instead of the .xls file. Check which other import formats Outlook can handle - I've done Access before so maybe dump it in a table first.

Don't know otherwise - does it make a difference if you sort the data in a different manner?

 

[[OUPA]MrNutz]

hey there...

i dediced to go the access route...... copied all the info from xls to mdb and imported it without ANY problems

thanks for all your inputs!!