![]() |
export public contacts
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 |
export public contacts
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. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- 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 |
export public contacts
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 "Michael Bauer" wrote in message .. . 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. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- 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 |
export public contacts
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 -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- 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 "Michael Bauer" wrote in message .. . 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. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- 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 |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com