On 10/4/02 11:35, SVEN AERTS wrote: > On 04-10-2002 16:48, "Allen Watson" <[EMAIL PROTECTED]> wrote: > >> Sven said in his original post that he created these files with Excel. >> Apparently, something he is doing there is not as he thinks. He said: >> >>> I want to import emailaddresses I gathered from relevant YahooGroups to our >>> organisation. I copy pasted them in an Excell sheet, now want to import them >>> in EntX Contacts. in Excell, I do a save as tab delimited text file. >> >> Excel (one "l") will export each row of a table as a "record" ending with >> Return, and will put commas or tabs (depending on which you choose) between >> the data from each cell in the row. Sven, sounds to me like you did not >> format the data in Excel properly before exporting it. > > Ah, well, I just selected say 50 email adresses, copy/pasted them in Excel: > 1 email adress/cell, save as ... In the different formats available and > mentioned earlier.
If you only have one column of data, then Entourage doesn't 'see' any tabs or commas...just the return at the end of each line...so it probably doesn't realize it's a valid data file. Try putting your addresses in Column B, and in Column A put something...a space will work, and fill down for as many rows as you have email addresses in Column B. Now when you save as a tab-delimited file, there will be two 'fields' for each address. You'll also probably want to put 'headers' in Row 1; First Name for Column A, and Email Address 1 for Column B. Now you should be able to import OK. I don't think you'll end up with anything for the name if you use a <space., but if you do, a simple AppleScript will remove any bogus names. George -- George Clark - [EMAIL PROTECTED] -- To unsubscribe: <mailto:[EMAIL PROTECTED]> archives: <http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/> old-archive: <http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
