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