ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List all e-mail addresses in Contacts in excel (https://www.excelbanter.com/excel-programming/413858-list-all-e-mail-addresses-contacts-excel.html)

Les

List all e-mail addresses in Contacts in excel
 
hi, is it possible to get all the contact e-mail addresses from outlook and
put them in a list in excel ??

--
Les

Gord Dibben

List all e-mail addresses in Contacts in excel
 
Yes

Open Outlook and FileImport and Export.

Select Export to a File then follow your nose from there.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 11:01:24 -0700, Les wrote:

hi, is it possible to get all the contact e-mail addresses from outlook and
put them in a list in excel ??



Les

List all e-mail addresses in Contacts in excel
 
Thanxs Gord, but is it possible to do this with code ??
--
Les


"Gord Dibben" wrote:

Yes

Open Outlook and FileImport and Export.

Select Export to a File then follow your nose from there.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 11:01:24 -0700, Les wrote:

hi, is it possible to get all the contact e-mail addresses from outlook and
put them in a list in excel ??




Gord Dibben

List all e-mail addresses in Contacts in excel
 
Probably

I'm not a very good coder, but the macro recorder may give you some lines to
work with?


Gord

On Thu, 10 Jul 2008 13:10:03 -0700, Les wrote:

Thanxs Gord, but is it possible to do this with code ??




All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com