We need to export the "sent" date/time on a contact. This is the TRUE creation date of the contact; we recently went through an Exchange migration and the created date/time is from when we migrated the data over.
We can't export this through the traditional export function in Outlook as the sent field isn't there. I also tried copy/paste from Outlook directly in to Excel, and while this works, it breaks many of the contacts up to a second line (I see this even when I copy/paste into notepad, so it's not a delimiter type issue.)
My thought is to use a VBA to grab the sent date and drop it in the user1 field for each contact, since that is exportable. But I don't know the first thing for generating that code. I did some digging, but not turning up much useful info.