资 源 简 介
Use e2o to move traditional Excel based phone lists to Outlook contacts.
created in 2010 by Rick Morrow
The primary goal is to move the records in an Excel based office phone list (single worksheet with a header row followed by rows of contact information) to an Outlook contacts folder creating one contact for each row in the Excel worksheet.
If you have MobileME the contact folder will then sync with your iPhone. Yeah!
The two key features of the initial release are the routines to: (1) clean up inconsistencies in the telephone numbers and (2) allow you to select and apply contact property names to replace the headers in the header row.
To clean up the inconsistencies, you select a column, build a mask, then apply the mask to the column of phone numbers. Be sure to check "report errors" to recursivly correct the column.
Just a note, ff your Excel data ia properly formatted you might save time with an export from Excel and an