How to Pull Outlook contact info into Excel

[Shaun H]

Hey Group,

I've got a spreadsheet that lists a bunch of contacts. They same
contacts reside in Outlook. In the past I've always retyped the
contact info into the spreadsheet. Is there a way that it can
automatically pull this information? Or a script button I can click on
to get the info? I've done some searching, but either not finding
what i'm looking for or not understanding it completely.

Thanks!
Shaun

 

[Bob I]

In Outlook, click File, Import and Export,.......

 

[Shaun H]

Sorry, should have stated 2007...

so how does one import directly from Outlook?

 

[Gord Dibben]

Sorry, should have stated 2007...

so how does one import directly from Outlook?

 

[Gord Dibben]

One exports from Outlook.


Gord Dibben MS Excel MVP

 

[Bob I]

Sorry, you don't. You "export from" and you "import to". So, open
Outlook, click File, Import and Export, the next steps of exporting
should be obvious.

 

[Shaun H]

Sorry, you don't. You "export from" and you "import to". So, open
Outlook, click File, Import and Export, the next steps of exporting
should be obvious.







- Show quoted text -

Thanks for all your help... I know how to export out of outlook..
Those are the steps I'm trying to avoid... With some sort of code, I
was hoping to run a macro to just do it for me.

 

[Bob I]

Thanks for all your help... I know how to export out of outlook..
Those are the steps I'm trying to avoid... With some sort of code, I
was hoping to run a macro to just do it for me.

I run AutoIT to perform some appointment imports "automatically". That
is a scripting program that is available free to use from the authors
web site.