 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / April 2006export 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 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.  SignatureViele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- > Dear, > [quoted text clipped - 3 lines] > thank you very much > William 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 Wed, 26 Apr 2006 10:51:06 +0800 schrieb William: > [quoted text clipped - 9 lines] >> thank you very much >> 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 SignatureViele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- > Dear, > [quoted text clipped - 22 lines] >>> thank you very much >>> William 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 Wed, 26 Apr 2006 10:51:06 +0800 schrieb William: >> [quoted text clipped - 9 lines] >>> thank you very much >>> William |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.