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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export appointment from calender to Excel (include Contact) 1
Word to Excel: Export comments with text and line number 0
Export Body to Excel 3
VBA Macro that Runs nightly to export folder 0
Outlook 2003 - Contacts view by Company 1
export table from outlook to excel 0
Export text of Search Results to Excel 1
How to export excel sheet to CSV 1

Back
Top