On Tuesday, April 20, 2004 at 6:56:53 PM, you wrote: > This question was answered some time ago, but I can find the answer > neither in my own databases nor in the archives.
> How can one move a list of e-mail addresses into the AB? I have > several last names in one column of 1-2-3 spreadsheet, first names in > another column, and e-mail addresses in another column. I'd like to > make them all individual entries in one contact group. OK: 1 Delete all other columns from spreadsheet - retaining first name column, last name column and email address column. 2 Place the columns in this order: first name, last name, email address. 4 Add a column between the first name and the last name columns with the same set of obscure characters in every cell - say 8fvw 5 Export as a CSV file. If you have the option to export with quotes around the cell contents then do so. 6 Open CSV file in a text editor. 7 Add a first line, if the export didn't do so, that says: "name","email" 8 Find and replace the following: ","8fvw"," with a space character - I can't illustrate that here. 9 So now you should have a file that looks like this: "name","address" "John Bloggs","[EMAIL PROTECTED]" "Another Name","[EMAIL PROTECTED]" etc etc. 10 Save this file. 11 Open TB Address Book. 12 Right click on the address collection and create a new folder, give it a name and a handle. Should now have a blank group list. 12a Keep it open and go to File>Import>From comma-seaprated (plain text) 14 Import it and you get the options as to what to translate the two fields of each record to - name to name and email to email I guess. 15 Hit OK and it should happen. Alternatively send me the exported spreadsheet (CSV preferably) an I'll do all that for you and all you have to do is the import bit! Marten Gallagher -- Annery Kiln Web Design Delivering Information Effectively www.annerykiln.co.uk Web Design and Site Management Web Hosting and Print Design This e-mail is intended solely for the addressee and is strictly confidential. If you are not the addressee, please do not read, print, re-transmit, store or act in reliance on it or any attachments. Instead please e-mail it back to the sender and delete the message from your computer. The system used to send this message is permanently checking for viruses and malicious scripts. However, email transmission cannot be guaranteed to be secure or error free and annerykiln.co.uk accepts no liability for changes made to this e-mail (and any attachments) after it was sent or for viruses arising as a result of this e-mail transmission. Any unauthorised reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message is strictly prohibited. mailto:[EMAIL PROTECTED] ________________________________________________ Current version is 2.10.01 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
