https://sourceforge.net/projects/bulkvcftocsv
Last week I had to combine 3 sources of contact data into one address book. The sources were: A google account, an iPhone’s local address book and an email account on Office 365. The Google account had 300+ contacts, the iPhone had 3,000+ contacts and the exchange account had 700+. The Exchange account was the desired destination of the combined data. Exporting the data from gmail’s web interface and iCloud’s web interface was easy but when I imported the exported data into Outlook, I was only getting one contact from a file that should have had 3000+ contacts. I remembered that some programs have issues with VCF files that have multiple entries and assumed that this was the issue here. Google brought me to Greg’s excellent converter.
On gmail, I exported to “vCard format”. On iCloud, there was no option, it just downloaded a file in VCF format. Each of these files had multiple contacts in it and did not import correctly into Outlook. After enabling Macros in Excel, I opened the VCF IMPORT macro file. It prompted me for a source VCF, did its magic and created a .CSV with a name that matched the source VCF except for its extension, in the right format for Outlook to import. I was able to import both of the new CSV files without issue into Outlook.
I did try directly importing google’s “Outlook CSV” but there was an error, which I don’t remember right now.
For safety’s sake, I made all of these changes into a separate Outlook PST file and imported each sources data into a separate folder. I then copied and combined the data from all three sources into a new folder on the same PST. Once this was done, I transferred the PST to the user’s computer, deleted his contacts and copied only the combined contacts folder into his Outlook. After the copy was complete, I closed the new PST to avoid user confusion. Keeping the original data in three different folders in a separate PST gives me the ability to quickly retrieve data that might have been overwritten or erroneously merged.
The macro is free and the author just asks for a review. I signed up on SourceForge just to leave the review and decided to also put this up in hope that his macro gets a bit better known.
Recent Comments