export public contacts

  • Thread starter Thread starter William
  • Start date Start date
W

William

Dear,

i would do a macro for export contacts stored in public folder but i could
not find a suitable vba method to do it. any help?

thank you very much
William
 
Am Wed, 26 Apr 2006 10:51:06 +0800 schrieb William:

You can call each item´s SaveAs method and store them in single files or
copy each field into any file, Excel e.g. There´s no Export function.
 
Dear,

let me explain in detail that i want.
i would use outlook public contacts as a central contact database for whole
company those contacts will reuse for several prepous in excel, such as
invoice, quotation, purchase...
i can't find an method to read outlook public folder from excel, so i try
export public folder to a database that excel can read.
it is quite difficult for me, any help for me?

thanks,
William
 
Am Thu, 27 Apr 2006 20:16:47 +0800 schrieb William Cheung:

You can read from Excel every folder like you´d do from Outlook. Please add
a reference onto Outlook to your Excel project via Tools/References. You can
then walk through Outlook´s folder hierarchy or use the function GetFolder
from www.outlookcode.com/d/code/GetFolder.htm
 
Back
Top