VBA export to excel

  • Thread starter Thread starter Christian Zimmermann
  • Start date Start date
C

Christian Zimmermann

Hi Newsgroup,

how can I export a public contact folder to an excel sheet with vba?

Thanks in advance.

Best regards,
Christian
 
Am Tue, 13 Dec 2005 14:02:31 +0100 schrieb Christian Zimmermann:

Christian, the Export wizard can´t be accessed via the Outlook object model.
So you need to iterate through the folder yourself, read each item´s
properties and write them into the workbook.
 
Back
Top