View original (French)

[EXCEL - OUTLOOK] data sharing

cocci1606 Posted messages 10 Status Member -  
UsulArrakis Posted messages 7683 Status Contributor -
Bonjour,

Is there a way to read/retrieve information from Outlook contacts using basic Excel functions, search the database, etc.?
Or do you need to use VB?
Or is it not possible at all?

Thank you for your help
Configuration: Windows XP Internet Explorer 7.0

3 answers

Answer 1 / 3
UsulArrakis Posted messages 7683 Status Contributor 3 196
 
Hello
I don't really understand!!!
Do you want to retrieve information that is in the "contacts" folder of Outlook and put it into an Excel file?

If so: in Outlook, go to the file menu/import and export/export to a file/Excel/select your "contacts" folder/give it a name and a location/validate
--
(_Usul of Arrakis
Serial_Dreamer_)
0
Answer 2 / 3
cocci1606 Posted messages 10 Status Member
 
Almost...
Actually, I would like to do it in 'real-time': in an Excel file, to be able, for example, with a click of a command button that I would have created, to open the Outlook contacts, select a contact, and have the corresponding fields for that contact displayed in cells that I have defined in my Excel file.
So let's forget about import/export...
I'm not sure if I'm being clear...
We'll see! ;)
Thanks anyway.
0
Answer 3 / 3
UsulArrakis Posted messages 7683 Status Contributor 3 196
 
Here you need a macro but I don't know how to do it
see on the exceldownload forum or on veriti or on the pcastuces office forum
--
(_Usul of Arrakis
Serial_Dreamer_)
0