How to quickly convert or copy email addresses column in Excel to Outlook email list?
Supposing here is a column of email addresses, and what you need to do is copy these email to the To section of an Outlook email message as below screenshot shown. Except entering these email addressed one by one manually, is there any quick tricks to copy these email addresses to the To/CC/BCC sections of Outlook email message?
Convert email addresses in Excel to Outlook message with formula
Convert email addresses in Excel to Outlook message with Word
Convert email addresses in Excel to Outlook message with Kutools for Excel
Convert email addresses in Excel to Outlook message with formula
Convert email addresses in Excel to Outlook message with Word
Convert email addresses in Excel to Outlook message with Kutools for Excel
How to create an Outlook contact group from a list of email addresses, including a spreadsheet or a custom view. (Contact Group) from a List of Addresses. Just drag it to the contacts folder. If it's a text list of the addresses, one per line, copy them and paste into the members field of a new contact group. Vote Up 0 0 Vote Down Reply. When needing to convert a column of email addresses in Excel to a usable list in Outlook. Notes: These instructions work for both PC and Mac computers, Using Outlook or Outlook Web Access. The email addresses must be complete ([email protected]) and listed in a single Excel column to use these instructions successfully.
Add Text (add character/word to a specific location of each cell in a range.) |
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than300 powerful features; Works with Office2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Convert email addresses in Excel to Outlook message with formula
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
To copy email addresses from Excel cells to Outlook message, you can use this formula:
=J1&';'
Tip: In the formula, J1 is the email cell you use, you can change it as you need.
Then drag the autofill handle over the cells you need to apply this formula
Now you can copy these selected emails and paste them into the To or BBC or CC sections of Outlook Email Message window.
Convert email addresses in Excel to Outlook message with Word
Moreover, you can use Word to help you to convert email addresses in Excel to Outlook message.
1. Copy and paste the email addresses from Excel to Word document as Keep Text Only. See screenshot:
2. Select the emails and click Home > Replace to display Find and Replace dialog. See screenshot:
3. In the Find and Replace dialog, enter ^p into Find what textbox, and ; into Replace with textbox. See screenshot:
4. Click Replace All. Now you can copy the email addresses with semicolon to the Outlook message.
Convert email addresses in Excel to Outlook message with Kutools for Excel
With Kutools for Excel, a handy tool, you can apply Add Text utility to quickly add semicolon to each email for copying them to Outlook message.
with more than 120 handy Excel functions, enhance your working efficiency and save your working time. |
After free installing Kutools for Excel, please do as below:
1. Select the emails, and click Kutools > Text > Add Text. See screenshot:
2. In the Add Text window, enter semicolon ; into Textbox, and check After last character. See screenshot:
3. Click Ok or Apply, and then copy the email with semicolon to the Outlook email message.
Demo
Kutools for Excel: 300 + functions you must have in Excel, 60-day free trial from here |
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than300 powerful features. Supports Office/Excel2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
- So much easier to copy Excel list, copy as unformatted text in Word, find/replace the paragraph sign with ';<space>', recopy list and past into Outlook!
- To post as a guest, your comment is unpublished.You have a typo you may want to fix:
BBC or CC sections of Outlook Email Massage window- Thank you for the correction!
Are you planning on leaving a job and want to make sure you get a copy of all your emails in case you need to refer to them at a later point? Or maybe you just want to export them for backup purposes in case your Outlook PST file becomes corrupt, which happens quite often.
In any case, backing up your emails is always a good idea. Even if you are using a web service like Outlook.com or Gmail, it’s still not a bad idea to use a desktop client like Outlook to download all your mail so that you have it stored locally. Web services and giants like Microsoft and Google may seem immune to failure, but you never know when something catastrophic can happen.
In this article, I’ll show you how to export your Outlook emails in Outlook 2003, 2007, 2010, 2013 and 2016. I’ll also mention the procedure if you are using Outlook for Mac. It’s worth noting that the actual Import and Export Wizard is pretty much exactly the same across all versions, but the process of getting to the wizard has changed.
Exporting Emails from Outlook
If you are running Outlook 2003, 2007, 2010 or 2013, then check out my post on how to export Outlook contacts to see the procedure for getting to the import/export wizard. If you are running Outlook 2016, then click on File and Open & Export.
In the right-hand menu, click on the Import/Export button.
This will now bring up the Import/Export Wizard, which looks the same in all versions of Office. To get started, you want to select Export to a file.
On the next screen, you have to choose the type of file: either a CSV (Comma Separated Values) file or an Outlook Data File (PST). I normally always use PST, so that it’s easier to import back into Outlook, but you can choose CSV if you want to import the emails into another email client or even into a program like Excel or Word.
On the next screen, you have to choose what you want to export. If you want to get all your emails, you normally select Inbox and make sure that Include subfolders is checked. If you only want a small subset of emails, you can click on the Filter button and then put in various criteria to reduce the number of emails to export.
Click Next and you’ll now need to choose a location to save your CSV or PST file. There are several options that you can choose from that deal with how duplicates will be handled.
Finally, click Finish and you’ll get a window asking if you want to protect your PST file with an optional password. If you are going to use a password here, note that it should be more than 16 characters. Also, note that it’s not very secure and can easily be hacked using the right software.
That’s about it. You should now have a CSV or PST file with all your emails stored inside. You can now copy this file to a safe location for backup.
Export Emails from Outlook for Mac
If you are running the Mac version of Office, then the procedure for exporting emails is different. Actually, the file type is also different. On Macs, you only have one option: Outlook for Mac Archive File (.OLM).
Click on File and then Export.
A dialog will popup where you can choose which items you want to export to the archive file. You can choose from Mail, Calendar, Contacts, Tasks and Notes or you can choose from items in a specific category.
Click Continue and you’ll be asked where you want to save the file. That’s about it. There aren’t any other options when exporting from Outlook on a Mac.
Once you have your emails exported, you can read my post on how to import them to another email service like Gmail, if you are planning to switch.