PDA

View Full Version : Outlook contacts => Excel using VBA?



magician
02-10-2011, 09:03 AM
I'd like to export my Outlook 2000 contacts to Excel 2000. Thing is, I have many sub- and sub-sub folders in my contacts, and Outlook only exports one folder at a time. Looking for code to loop through all folders and dump into Excel workbook. I would be happy to take all the fields (not just name and email for example) if that makes it easy.

Using Windows XP Home 2002 SP3.

Thanks.

JP2112
02-10-2011, 02:32 PM
I would move the contacts into the default folder first. Then you can simply use Outlook's built-in export feature. I know that probably isn't what you're looking for.

magician
02-10-2011, 02:38 PM
I've done that in the past, actually creating a "Bulk" folder and putting every contact from all the sub-folders in there, export it, then delete it. I'm hoping to find a "simpler" way <ha ha> using VBA, since I have so many folders, it does take a while to amass that bulk grouping. But thanks for the suggestion. It is my Plan B.