Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   export public contacts (http://www.outlookbanter.com/outlook-vba/12832-export-public-contacts.html)

William April 26th 06 04:51 AM

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



Michael Bauer April 26th 06 06:23 AM

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


William Cheung April 27th 06 02:16 PM

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




Michael Bauer April 28th 06 07:09 AM

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 07:59 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