This content is 16 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.
Together with my colleague, Alan Dodd, I’ve spent a considerable amount of time this week cleansing data in a SharePoint list. Quite why I can’t import e-mail addresses from an Excel spreadsheet to a column of type “Person or Group” I don’t know, but we couldn’t seem to make it work…
Checking names or browsing the directory was tediously slow; then I found that if I pasted the e-mail address, rather than the person’s name, SharePoint immediately resolved that address to a name and let me move on to the next record… might be a timesaver for someone?