Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
read protpetry of user from a distribution list..
i read and import into a sheet the user into adistribution list.... is posisble to read the propety from each user into this list and insert into cell.? For example: Nmae, Address, phone, Ofice...eccc Sub ELENCO() Range("A2:B50000").ClearContents Set myOlApp = CreateObject("Outlook.Application") Set myNameSpace = myOlApp.GetNamespace("MAPI") Set myGAddressList = myNameSpace.AddressLists("Elenco Indirizzi Globale") Set myGEntries = myGAddressList.AddressEntries RIGA = 2 For Each lista In myGEntries If lista = "A.T.C.B. - Utenti" Then Range("A" + RIGA) = lista For Each NOM In lista.Members Range("B" + RIGA) = UCase(NOM) RIGA = RIGA + 1 Next NOM Exit For End If Next lista Range("A2").Select 'Call Worksheet_SelectionChange MsgBox ("IMPORT TERMINATO!") End Sub -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=484112 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distribution list from Excel | Excel Discussion (Misc queries) | |||
Excel Distribution list | Excel Discussion (Misc queries) | |||
import from distribution list | Excel Programming | |||
Is it possible to create distribution list for Outlook? | Excel Programming | |||
Email distribution list | Excel Programming |