The bad news? It can get a bit convoluted<\/strong> and requires bringing Microsoft Word into the equation when you’re sending through Microsoft Outlook. (And in complex cases, you might even need to bring Excel VBA and at least one VBA macro into the equation.)<\/p>\n More good news: There’s a simple solution<\/strong> to send your email blast which we’ll cover in this article.<\/p>\n In this article, I\u2019ll show you how to perform a mail merge using an Excel spreadsheet<\/strong> to send your personalized mass email messages whether they’re cold email<\/strong>, email marketing<\/strong>, or any other type of email campaign<\/strong>.<\/p>\n I\u2019ll also go into detail about common merge issues with MS Excel<\/strong>, as well as the fixes for those problems.<\/p>\n (Click on the links below to jump to a specific section)<\/em><\/p>\n A mail merge automatically fetches data from a spreadsheet (or other data source) and inserts it into an email template. This data can be your contacts\u2019 names, company names, or any other details. (You’ll need a list of addresses; it’s most common to put them in column A.)<\/p>\n To send a mail merge, you need two files:<\/strong><\/p>\n Here’s what your template file might look like.<\/p>\n When you’re sending email with a mail merge, your data file<\/strong> will be the spreadsheet that contains all your contacts’ details.<\/p>\n The mail merge function would then combine the email template<\/strong> with your data file<\/strong> to create individual emails for each contact.<\/p>\n The mail merging process automatically<\/strong> creates separate, personalized emails for each recipient. This way, you save tons of time as you\u2019re not wasting hours manually creating a new customized document for each person.<\/p>\n Imagine manually composing 100 different emails for 100 different recipients!<\/em><\/p>\n You can use mail merges without having to individually select recipient data from your Outlook contacts or elsewhere to send different documents like:<\/p>\n Mail merging is the most commonly used method to send mass emails.<\/p>\n Here, the data file<\/strong> will be a mailing list, which is usually stored in a spreadsheet, like Google Sheets<\/strong> or Excel<\/strong>. Your mail merge template<\/strong> will be the email that you send to your list.<\/p>\n However, sending mass emails from Excel with Microsoft Word Mail Merge can be challenging due to formatting errors and other issues<\/strong>.<\/p>\n Find out the most common Word mail merge formatting errors<\/a> you encounter when sending emails from Excel, as well as how GMass fixes these problems here<\/a>.<\/p>\n Unfortunately, an Excel mail merge is a time-consuming and often convoluted process to send bulk email with which many people struggle.<\/p>\n What if there was an easier way to send emails<\/strong> that were personalized to your entire mailing list? There is, and the solution is called GMass<\/strong>. You can use GMass to send email quickly and efficiently from Excel.<\/p>\n GMass<\/a> is a powerful mail merge tool<\/strong> that makes it incredibly easy to draft and send mass emails from Gmail.<\/p>\n Our ease coupled with the most robust feature set<\/strong> of any Gmail-based email service provider have led to 400,000+ users<\/strong> (leaving 9,000+ reviews<\/strong> with a 4.8\/5 star average<\/strong>).<\/p>\n What\u2019s<\/em> more \u2014<\/p>\n Anyone can get started with GMass immediately \u2014 just download the Chrome extension<\/a> and sign up with your email. There’s no credit card required<\/strong>\u2026 there’s not even a web form. It\u2019s that simple!<\/p>\n If you have your contact data saved in an Excel file rather than keeping it as Google Contacts<\/a>, GMass can easily use it to create a data merge that personalizes your emails to multiple recipients.<\/p>\n Here\u2019s a detailed walk-through for how to send a mail merge in Excel using GMass.<\/p>\n I\u2019ll be using the Excel spreadsheet, shown in the image below, to walk you through the process. The first step is to import your Excel spreadsheet<\/strong> into Google Sheets. (It just takes a few seconds.)<\/p>\n Google Sheets<\/a> is free and available to anyone. All you need is a Google account!<\/p>\n Note \u2013 If your contact data is in a CSV file, you can also import it into Google Sheets. Here\u2019s a LinkedIn Learning tutorial on how to import a CSV file into Google Sheets<\/a>.<\/em><\/p>\n Here\u2019s a step-by-step guide<\/strong> on how to import your Excel file into Google Sheets:<\/p>\n Voila!<\/em><\/p>\n Notice how my Google Sheet has the text \u2014 Ted\u2019s Tadpole Tanks <\/strong>\u2014 in the first row?<\/em><\/p>\n Remove text and blank rows from your spreadsheet for the mail merge (with GMass or, really, anything else).<\/p>\n Here, I\u2019m deleting rows 1 and 2 from my sheet: Once you\u2019ve selected the rows to be removed, click on the Edit<\/strong> menu and click Delete selected rows<\/strong>.<\/p>\n After deletion, the sheet looks like this:<\/p>\n Your spreadsheet should also have the following. . .<\/p>\n Here\u2019s a step-by-step guide on how to connect GMass to your Google spreadsheet:<\/p>\n Note –<\/strong> If there\u2019s only one sheet <\/strong>(Sheet1<\/strong>) in your Google spreadsheet, it\u2019s selected by default.\u00a0However, if your spreadsheet has multiple sheets<\/strong>, you can select the required sheet from the worksheet drop-down menu.\u00a0<\/em><\/p>\n Once you\u2019ve selected a spreadsheet, click on the Connect to Spreadsheet<\/strong>\u00a0button.<\/p>\n Click the Personalize<\/strong> drop-down list, and all the column names you added in your Google Sheets file will show up.<\/p>\n To personalize your email message, select the column names in your spreadsheet from the drop-down menu. You can insert these placeholders anywhere in your email subject and email body. Notice the {FirstName} label?<\/em><\/p>\n That\u2019s a personalization tag corresponding to the FirstName column in my Sheet.<\/p>\n Note \u2013 GMass will automatically<\/strong> personalize the email for each prospect or contact based on the mail merge labels you\u2019ve used in your email messages. For example, the second line of the spreadsheet, Brandon Walsh, will receive an email that starts with \u201cDear Brandon,\u201d since the {FirstName} label was used in the email body.<\/em><\/p>\n Even though you’re sending through Gmail you can still use your Outlook address<\/strong> for your email campaign. (You could also use a Yahoo mail address, AOL email address, and so on.)<\/p>\n And we even have a technique for sending mass email through Gmail with GMass where you can use your Outlook address \u2014 but still get the top-of-the-line deliverability<\/strong> by sending through Gmail’s servers. Here’s an explanation of how to set up that Gmail alias<\/a>. (It only takes a few minutes.)<\/p>\n It’s easy to do your mass emailing from Excel through Gmail\/GMass. But if you really want to keep everything within the Microsoft ecosystem, you can.<\/p>\n It’s just a little more complicated.<\/p>\n It\u2019s common for organizations to send mass emails using Outlook and Excel Mail Merge. You can use mail merge in Microsoft Office to create a form letter with unique personalization elements like greetings or salutations for each contact.<\/p>\nHow to Send Mass Email from Excel: Table of Contents<\/h2>\n
\n
How Does a Mail Merge Work?<\/h2>\n
\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/template-file.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/data-file.png\")
<\/p>\nHow do merges make your life easier?<\/h3>\n
\n
How to use mail merge for sending mass emails in Excel<\/h3>\n
Send mail merges easier with GMass<\/h3>\n
What Is GMass?<\/h5>\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/gmass.png\")
<\/p>\nHow to Send Mass Emails with Excel \u2014 The Easier Way<\/h2>\n
\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/sample-excel-sheet.png\")
<\/p>\nStep 1: Import Your Excel sheet into Google Sheets<\/h3>\n
\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/open-gsheets.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/open-file-picker.png\")
<\/p>\n\n
\nClick on the Upload<\/strong> tab to upload your Excel file.<\/li>\n<\/ul>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/gsheets-file-picker.png\")
<\/p>\n\n
\nTo select your file, click on the Select a file from your device <\/strong>button.<\/li>\n<\/ul>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/drag-or-drop-file.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/select-excel-sheet.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/excel-gsheets.png\")
<\/p>\nStep 2: Format your new Google spreadsheet<\/h3>\n
\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/select-rows.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/delete-rows.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/gsheets-after-deletion.png\")
<\/p>\n\n
Step 3: Connect GMass to your Google spreadsheet<\/h3>\n
\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/click-spreadsheet-button.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/choose-gsheet.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/connect-gmass-gsheet.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/gmass-compose-window.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/gmass-settings.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/gmass-personalization.png\")
<\/p>\n\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/personalized-email.png\")
<\/p>\n\n
Using your Outlook email address in Gmail<\/h3>\n
How to Send a Mass Email with Excel \u2014 The More Complicated Way<\/h2>\n
Send Personalized Mass Emails From Outlook with Excel<\/h3>\n
![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/format-excel-sheet.png\")
<\/li>\n<\/ul>\n<\/li>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/format-numeric-data.png\")
<\/li>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/number-formats.png\")
<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-letters.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-mm-wizard.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-select-recipients.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-use-excel.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-choose-excel-file.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-choose-excel-sheet.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-edit-recipient-list.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-address-block.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/address-block-tag.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-greeting-line.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-insert-fields.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-match-fields.png\")
<\/p>\n![\"shows](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2019\/12\/word-preview.png\")
<\/p>\n