create outlook email group from excel list

For example, the output will be 'dl.xxxxxx' in A2 cell, and in B2 cell, instead of retrieving all the members in the distribution list. It is only printing out the name of a distribution list, and its 'parent email'. Choose one of the options on how you want Outlook to treat duplicate contacts. Use the Import a File screen to browse to your CSV file. Choose the Comma Separated Values option and click on Next. Pick Import from another program or file and click on Next. NameĭestWorksheet.Cells(rowIndex, 'b').Value =. Click on Import/Export to start the wizard. With olDistListItem.GetMember(memberIndex)ĭestWorksheet.Cells(rowIndex, 'a').Value =.

Set olDistListItem = olContactFolder.Items(distListName)ĭestWorksheet.Range('A1:B1').Value = Array('Name', 'Address') 'column headers Set olContactFolder = olNamespace.GetDefaultFolder(olFolderContacts) Set olNamespace = olApplication.GetNamespace('MAPI')

Set olApplication = CreateObject('Outlook.Application') Sub PrintDistListDetails()ĭistListName = 'dl.xxxxxx' 'change the name accordingly I searched online for solutions that can directly export the members of Outlook distribution list to Excel, but didn't achieve my intended effect. My ultimate objective is to get the latest name and email address of the members found in a distribution list in Excel format. In that case, I can use macro A to export the latest DL members found in my contacts folder. I am trying to retrieve the members of a distribution list, and push them into my Outlook contacts folder on a daily basis. Click on the People icon within the bottom-left hand corner of Outlook.I have an Excel VBA macro (Macro A) to export the members' information (Name and Address) from Outlook contacts folder to Excel. Beneath Sidebar, un-tick the Hide On My Computer folders tick-box. Within the Outlook Preferences window, beneath Personal Settings, select General.ģ. Select the Outlook menu within the top-left corner. This is performed by selecting the following:ġ. Tip: If the Contact Group icon is greyed out, you will need to show 'On My Computer' folders within Outlook. They will not synchronise with the server which means that you will not see your local contact groups in Outlook Web Access or any other email clients that you use. Important: The groups created will only be available in Outlook 2016 for Mac. This guide demonstrates how to create a Contact Group. Create a Contact Group (local distribution list) in Outlook 2016 for MacĪ Contact Group is a distribution list saved within Outlook only (local distribution list), where you can manage your own list of members.

Create outlook email group from excel list