AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Create email list in apple mail4/30/2023 ![]() Maybe, someday, someone at Apple will add this capability to mail. The email names and addresses are now in filename.txt, one per line. Sqlite:> select ZLASTNAME, ZFIRSTNAME, ZEMAIL from ZABCDMAILRECENT ĭone. ![]() width 15 15 36 /* make sure the columns are wide enough */ We want these from the table, in columns, in filename.txt. Note that the last 3 columns are called ZLASTNAME, ZFIRSTNAME, and ZEMAIL. The table ZABCDMAILRECENT is of interest to us. You can also select File > New > Contact List from the menu bar. Select People from the bottom left of the Outlook window. Now, let’s get some information about what’s in this database file: sqlite> select * from SQLITE_MASTER /* don’t forget the semicolon */ Open Outlook on your Mac and get ready to create your contact list. MailRecents-v4.abcdmr: SQLite database (Version 3) Note that the file command describes this as: $ file MailRecents-v4abcdmr The file of interest is MailRecents-v4abcdmr. Also, there is information on the web, at A friend whose day job is in database administration helped me work this out.įirst, go the proper directory in a terminal window: cd ~/Library/Application Support/AddressBook For information about this program, type “man sqlite3” in a terminal window. ![]() ![]() The Apple mail program uses a database program available in Unix called “sqlite3.” This turns out to be more complicated than I had hoped, but it is possible. If you want to export the list to a file, you can do so in the Terminal by directly accessing the sqlite database with sqlite3. You can then add them to your Address Book. In Mail, go to Window -> Previous Recipients.
0 Comments
Read More
Leave a Reply. |