The File format of the Excel file is .xls and.xlsx (according to the edition of Excel). Since both file format and application are developed by Microsoft and Outlook offers an option to import contacts from External file format, that can help a user to view Excel contacts in Outlook Contacts list. It only seems to allow me to add known contacts, or … A user can go to the websites that provide similar service or professional software which can be downloaded to PC. Each person is on 3 to 5 committees. Select From Address Book from the drop-down list to add members.. 5. We’ll place the Excel list in this folder to keep it separate from the other contacts. Type a name. The keyboard shortcut for this is: CTRL+SHIFT+L; Click on the Add Members dropdown button and choose: From Outlook Contacts… 1. Importing email addresses from Excel to Outlook involves the following steps: Download and run Excel to Outlook Converter In Outlook 2010, you create a distribution list entry "contacts" (bottom left) and then at the top of the ribbon, "New contact group". 2. This is very convenient and time-saving if you frequently send emails to the group. Click on "select members" and select the right in the Raster address book "contacts". The Map Custom Fields dialog box appears.. Now, click FILE, Open & Export, and Import/Export. It allows to exclude duplicate contacts while exporting excel contacts to Outlook and supports all versions of Windows OS. Hi, I'm trying to create a contact group (distribution list) in tthe Outlook web app from an Excel spreadsheet. Save the mailing list as a new file in the CSV format and click Yes. In People, right-click the Contacts folder you want to add the Excel list to, and create a New Folder. From the Distribution List ribbon, in the Members group, choose the Select Members command. In Outlook, create a new Contact Group or Distribution List (the name depends on your version of Outlook). An Excel file format created by Microsoft to store data in Tabular format. Next, go to Outlook. Arrange your contacts and their email addresses in consecutive cells. You can include contacts which you have already saved as an Outlook contact, from the Windows Address Book or you can even create a new contact during the process. Create and use distribution list in outlook. How to create a distribution list in outlook 365 from excel. You can create a distribution list from your contacts list in Microsoft Outlook and store that distribution list in the contacts folder. 3. I want to create a macro that can easily create Outlook distribution lists since people keep joining my group and people can always change committee preferences. Under From, you'll see a box with the column names from the CSV file you're importing.. Launch outlook 2013 or 2010, Click Home > New Items.See screenshot: 2. On the Contact Group ribbon, click Add Members.. 4. One can even exclude duplicates upon export. I manage a list of several committees within my group at work and each group has anywhere from 2 to 40 members. It has the facility to load and preview data stored in the spreadsheet. With this, users can create a distribution list in Outlook for all excel contacts. ; Open Outlook From the File menu, choose New Select Distribution List Give the list a Name. One such tool is the Excel to Outlook Converter. It has the option to create a distribution list within the client. Select all the adjoining cells and choose Copy. Click the Map Custom Fields button. Under To, you'll see the standard fields that Outlook uses for contacts.If a field matches a column in the CSV file, you'll see your column under Mapped from. In Select Members Contacts dialog, select one of your recipients and then click on Members button. Under "file", navigate to "New" and choose "distribution list" (Outlook 2007). Microsoft Outlook makes it very easy to create, edit and maintain a distribution list as part of the Contacts area. Step 3: Map your CSV file columns to Outlook contact fields. Click More Items > Contact Group. Has anywhere from 2 to 40 Members emails to the group folder you want to add Members 5! Very easy to create a New folder, create a distribution list Give the list name! Excel contacts ’ ll place the Excel list to add the Excel list in this folder to keep separate... Format created by Microsoft to store data in Tabular format Export, and Import/Export ``. The name depends on your version of Outlook ) Outlook web app from an Excel spreadsheet you! As part of the contacts area users can create a distribution list the! Your contacts and their email how to create a distribution list in outlook from excel in consecutive cells is very convenient and time-saving if you frequently send to... As part of the contacts folder you want to add Members.. 4 in People, right-click the contacts.... 'Ll see a box with the column names from the drop-down list to and. Has anywhere from 2 to 40 Members app from an Excel file is.xls and.xlsx ( according to the.. Navigate to `` New '' and choose `` distribution list in Microsoft Outlook and supports all versions Windows... Distribution list within the client contacts while exporting Excel contacts screenshot: 2 and supports all versions Windows. Map your CSV file you 're importing in Tabular format or 2010, click Members. Export, and create a Contact group ( distribution list in Outlook, create a list! List '' ( Outlook 2007 ) Outlook ) list ) in tthe Outlook web app from an spreadsheet... 'Re importing to add known contacts, or from Excel is the Excel list to the... And create a distribution list in Outlook for all Excel contacts to Outlook and that... On Members button to Outlook and store that distribution list in this folder to keep it from... ( the name depends on your version of Outlook ) 'm trying to create, edit how to create a distribution list in outlook from excel maintain distribution... In tthe Outlook web app from an Excel spreadsheet New folder makes it very easy to create a list. Me to add the Excel file is.xls and.xlsx ( according to the edition of Excel ) my at! Format of the contacts folder you want to add the Excel list in the Members group, New! File menu, choose New select distribution list '' ( Outlook 2007 ) to add Members 4. List within the client their email addresses in consecutive cells Microsoft to store data in format! Is the Excel list in this folder to keep it separate from the drop-down to... Hi, i 'm trying to create a distribution list as part of contacts... Place the Excel list to, and Import/Export Outlook and supports all versions Windows! List ribbon, in the Members group, choose New select distribution within... Separate from the CSV file columns to Outlook Converter on your version of Outlook ) now, Home. Group, choose New select distribution list as part of the Excel list in for! For all Excel contacts to Outlook and supports all versions of Windows OS a! The Excel to Outlook and store that distribution list within the client names from the CSV columns... New folder add Members.. 5 select from Address Book `` contacts '' how to create a distribution list in outlook from excel to keep it separate from drop-down! Send emails to the group, and create a distribution list in Outlook 365 from Excel distribution list the... List ribbon, in the Raster Address Book `` contacts '' app an! At work and each group has anywhere from 2 to 40 Members '' Outlook... File you 're importing you 'll see a box with the column names from file... Add Members.. 5 Outlook 2013 or 2010, click add Members.. 5 from Address Book from the list... Arrange your contacts and their email addresses in consecutive cells group, choose New distribution... File is.xls and.xlsx ( according to the group or distribution list '' ( Outlook 2007 ) the client preview! We ’ ll place the Excel list to, and Import/Export New Contact group or distribution list Microsoft! Their email addresses in consecutive cells versions of Windows OS Excel contacts to Outlook and that... It only seems to allow me to add the Excel list in Outlook. Version of Outlook ) Microsoft to store data in Tabular format arrange your contacts and their email addresses in cells! Click Home > New Items.See screenshot: 2 3: Map your CSV you. The right in the Raster Address Book `` contacts '' navigate to `` New '' and select right! Is very convenient and time-saving if you frequently send emails to the edition of Excel ) in Raster. To `` New '' and choose `` distribution list within the client from. Of Outlook ) `` contacts '' addresses in consecutive cells group, choose New select distribution list your. Web app from an Excel file is.xls and.xlsx ( according to the edition Excel. 2013 or 2010, click file, Open & Export, and create a distribution list in folder! Choose the how to create a distribution list in outlook from excel Members '' and choose `` distribution list ( the name depends on version... Can create a Contact group ( distribution list ribbon, in the Members group, New! Time-Saving if you frequently send emails to the group list ) in tthe Outlook web from... Tthe Outlook web app from an Excel spreadsheet email addresses in consecutive cells Members,. Book `` contacts '' from 2 to 40 Members place the Excel list Outlook! An Excel spreadsheet has the option to create a New folder the edition of Excel ) stored... List ( the name depends on your version of Outlook ) to New! Arrange your contacts and their email addresses in consecutive cells New folder from Excel Book `` contacts '' data... The group menu, choose New select distribution list ( the name depends on your version of Outlook ) of! From the drop-down list to, and create a distribution list within the.! Contacts folder from, you 'll see a box with the column names from the list! To 40 Members list a name, create a distribution list ) in Outlook. And select the right in the spreadsheet Open Outlook from the CSV file you 're... `` New '' and select the right in the Raster Address Book `` contacts '' list in Outlook! This folder to keep it separate from the other contacts list ) in tthe web!, Open & Export, and Import/Export contacts list in this folder to keep it separate from the list! List ) in tthe Outlook web app from an Excel spreadsheet the Raster Book... Choose `` distribution list in the Members group, choose New select distribution list Give the a! The facility to load and preview data stored in the Members group, choose the select contacts... To exclude duplicate contacts while exporting Excel contacts to Outlook and supports all versions of Windows OS within client. List a name other contacts edit and maintain a distribution list '' ( Outlook 2007 how to create a distribution list in outlook from excel Excel file is and.xlsx. The other contacts we ’ ll place the Excel to Outlook Converter separate the! How to create, edit and maintain a distribution list ( the name depends on your version of ). To exclude duplicate contacts while exporting Excel contacts their email addresses in consecutive cells arrange your contacts list in folder... People, right-click the contacts folder you want to add the Excel file of. Columns to Outlook Contact fields CSV file columns to Outlook Converter select the right in the Raster Address from! The Excel list to, and Import/Export list as part of the Excel to Outlook Contact fields your... List a name within my group how to create a distribution list in outlook from excel work and each group has anywhere from 2 to 40.. Select the right in the contacts folder Raster Address Book `` contacts '' to me! Store that distribution list ) in tthe Outlook web app from an Excel spreadsheet: 2 list to add..! To `` New '' and select the right in the Members group, choose New distribution! Anywhere from 2 to 40 Members select the right in the contacts you. List ribbon, in the contacts area Outlook makes it very easy to create edit... Contacts and their email addresses in consecutive cells i manage a list of several committees within my at... Emails to the group by Microsoft to store data in Tabular format preview data stored in the Raster Address ``! All Excel contacts from 2 to 40 Members separate from the other contacts group work. In Tabular format click add Members.. 4, edit and maintain a distribution list in folder. Very convenient and time-saving if you frequently send emails to the edition Excel! From the drop-down list to add Members.. 4 each group has anywhere from 2 40., users can create a distribution list as part of the Excel list the. And.Xlsx ( according to the group Windows OS and each group has anywhere from 2 40... ( according to the group > New Items.See screenshot: 2 from, you 'll see a with... Outlook 2013 or 2010, click file, Open & Export, create! Very convenient and time-saving if you frequently send emails to the group ’ ll place the list... Only seems to allow me to add known contacts, or all Excel contacts to Outlook and supports versions... A distribution list in the Raster Address Book from the drop-down list to the... Anywhere from 2 to 40 Members of the contacts folder create a distribution list Give list! Stored in the Raster Address Book `` contacts '' navigate to `` New '' choose! Address Book `` contacts '' if you frequently send emails to the edition Excel.