How to convert distribution list to individual contacts in Outlook?
When you receive a distribution list send from others, after saving the distribution list to the Contacts folder, how can you convert this contact group to individual contacts in Outlook? Actually, Outlook provides you with no feature for solving this problem. But there still are methods for it. Please look at the following tutorial.
Convert distribution list to individual contacts with expanding and saving one by one
Convert distribution list to individual contacts with importing
Step 1: Save the Distribution list as txt file
Step 2: Save the txt file as csv-file in Excel
Step 3: Make sure that the contacts and Email Addresses are separated by Commas
Step 4: Import the CSV file to Outlook contacts folder
- Automate emailing with Auto CC/BCC, Auto Forward by rules; send Auto Reply (Out of Office) without requiring an exchange server...
- Get reminders like BCC Warning when replying to all while you're in the BCC list, and Remind When Missing Attachments for forgotten attachments...
- Improve email efficiency with Reply (All) With Attachments, Auto Add Greeting or Date & Time into Signature or Subject, Reply Multiple Emails...
- Streamline emailing with Recall Emails, Attachment Tools (Compress All, Auto Save All...), Remove Duplicates, and Quick Report...
Convert distribution list to individual contacts with expanding and saving one by one
If there are not so much members existing in the distribution list, I recommend you to use this method for converting distribution list to individual contacts in Outlook.
1. First, you need to save the distribution list sent from others by dragging it to Contacts Folder, then create a new email message.
2. In the Message window, click the To button to select the distribution list which you want to convert to individual contacts.
3. When the distribution list showing in the To field, please click the button to expand the distribution list.
4. Then an Expand List prompt box pops up, please click the OK button. See screenshot:
5. After expanding the distribution list, please select and right click the first contact, and then click Add to Outlook Contacts in the right-clicking menu. See screenshot:
6. Now the Contact window pops up, please click the Save & Close button to save it after finishing filling all the information for this contact.
7. You need to repeat the above step 5 and 6 to create new contacts from the distribution list until all members are saved to your contacts folder.
8. After saving all contacts of the distribution list, close the Message window without sending.
Convert distribution list to individual contacts with importing
If there are amount of members included in the distribution list, the following import method will do you a good favor.
Step 1: Save the Distribution list as txt file
1. After saving the distribution list into your Contacts folder, shift to the Contacts or People view, select and open the distribution list you want to convert to individual contact.
2. Click File (Office button in Outlook 2007) > Save As.
3. In the Save As dialog box, you need to:
1). Select Text Only in the Save as type drop-down list;
2). Select a location to save the text file to;
3). Name the file in the File name box;
4). Click the Save button.
Step 2: Save the txt file as csv-file in Excel
Now you need to save the txt file as csv-file in Excel. Please do as follows.
1. Open an Excel workbook.
2. In the Excel worksheet, please type the word βNameβ in the cell A1, and in cell B1, type βE-mail Addressβ. See screenshot:
3. Open the txt file you have created in the Step 1, select the lines only with the names and email addresses. Then press Ctrl + C to copy the selected items.
4. Go back to the Worksheet, click the cell A2, then press Ctrl + V to paste the selected items to the worksheet.
5. Then click File (Office button in Outlook 2007) > Save as in Excel.
6. In the Save As dialog box, you need to:
1). Select a location to save the CSV file to;
2). Name the file in the File name box;
3). Select CSV (MS-DOS) from the Save as type drop-down list;
4). Click the Save button.
Step 3: Make sure that the contacts and Email Addresses are separated by Commas
1. Open the CSV file in Notepad with right-clicking it, then click Open with > Notepad. See screenshot:
2. Make sure that the Names and the E-mail Addresses are separated by commas.
Notes:
1. If they are separated by commas, please close the Notepad window;
2. If the separators are not commas, for example they are semi-colon, please click Edit > Replace in the Notepad window. In the Replace dialog box, type the semi-colon (;) in the Find what box, and type comma (,) in the Replace with box, then click Replace All to replace all semi-colons with commas. See screenshot:
Step 4: Import the CSV file to Outlook contacts folder
Now, you can import the csv file to Outlook contacts folder.
1. Open the Import and Export Wizard dialog box.
In Outlook 2007, please click File > Import and Export;
In Outlook 2010, please click File > Open > Import;
In Outlook 2013, please click File > Open & Export > Import/Export.
2. In the Import and Export Wizard dialog box, click Import from another program or file, then click the Next button.
3. In the Import a File dialog box, click Comma Separated Value (DOS), and then click the Next button.
4. In the next Import a File dialog box, please click the Browse button to find and open the CSV file you have created; then click the Next button.
Note: The three Options are optional for your own needs.
5. In the next dialog box, please select a Contacts folder which you want to save the contacts in the Select destination folder box. Then click the Next button.
6. In the last dialog box, click the Finish button to start importing.
7. Then an Import and Export Progress dialog box pops up, after finishing importing, it will be closes automatically.
Best Office Productivity Tools
Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook
π€ AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...
π§ Email Automation: Out of Office (Available for POP and IMAP) / Schedule Send Emails / Auto CC/BCC by Rules When Sending Email / Auto Forward (Advanced Rules) / Auto Add Greeting / Automatically Split Multi-Recipient Emails into Individual Messages ...
π¨ Email Management: Easily Recall Emails / Block Scam Emails by Subjects and Others / Delete Duplicate Emails / Advanced Search / Consolidate Folders ...
π Attachments Pro: Batch Save / Batch Detach / Batch Compress / Auto Save / Auto Detach / Auto Compress ...
π Interface Magic: πMore Pretty and Cool Emojis / Boost Your Outlook Productivity with Tabbed Views / Minimize Outlook Instead of Closing ...
π One-click Wonders: Reply All with Incoming Attachments / Anti-Phishing Emails / πShow Sender's Time Zone ...
π©πΌβπ€βπ©π» Contacts & Calendar: Batch Add Contacts From Selected Emails / Split a Contact Group to Individual Groups / Remove Birthday Reminders ...
Over 100 Features Await Your Exploration! Click Here to Discover More.