#Excel mail merge how to#

From here, you can send out your personalized emails as you normally would in GMass.In the To field, the email addresses of the contacts from your Google Sheet have now been populated.ДЄ new Gmail compose window, with email addresses from our spreadsheet. The GMass Google Sheets chooser window will be gone, and now youвЂ™ll see a Gmail Compose Window is open. Click the red bar button to connect GMass to the Google Sheets spreadsheet. Click on theВ вЂњ CONNECT TO SPREADSHEETвЂќ button. Then, once you have selected a spreadsheet, the вЂњCONNECT TO SPREADSHEETвЂќ button will turn red.

Selecting the spreadsheet we just uploaded into Google Sheets from Excel.

This will bring up a window allowing you to select the Google Sheets spreadsheet you want to use to populate the email addresses in your mail merge.ДЇrom this window, select a spreadsheet from the dropdown.

Now go to Gmail and click on GMassвЂ™s red spreadsheet button near the top to connect to an email list in a Google Docs spreadsheet.Д¬lick the spreadsheet button to connect to your Google sheet.

Our quickly cleaned-up sheet should now looks like this and your list of email addresses is ready to use with GMass for your Gmail mail merge:

Select Edit from the menu, and drop down to select вЂњDelete rows 1 вЂ“ 2вЂќ.Two rows that we want to delete are selected. Do that by holding down shift, clicking on the row number, 1 and then row 2, which will select both these rows: LetвЂ™s do that by selecting the two rows above and just deleting them. So, you will need to just make sure there is nothing above these columns. ThatвЂ™s because this spreadsheet has text above the columns that hold the FirstName, LastName, and Email fields, and that will introduce an error. However, before we can use it in GMass, we have to edit it, very slightly and quickly. This will then be uploaded to Google Sheets and converted into a new Google Sheet spreadsheet.Selecting the Excel file from your desktopвЂ™s File Manager via Google Sheets. From here, pick your Excel spreadsheet from the file manager on your computer.Click on the blue вЂњSelect a file from your computerвЂќ button.ДЄbout to select our Excel spreadsheet after clicking here. The screen will change, asking you to either drag or select a file from your computer.Click on Upload.Д¬lick on Upload to select your Excel file. This will bring up the Google Sheets File Picker, allowing you to pick your Excel file to upload.

Click on the folder icon on the right to open the File Picker.Д¬lick this folder icon to open the File Picker.

(In our example, it will start with no sheets in your case, you may have previous spreadsheets already there.) To do that, make sure you are logged into your Google account, and then go to Google Sheets.

Now we want to import this list of email addresses into Google Sheets.

First, we start with our Excel spreadsheet, in this case one with a few customers of Ted, our fictional shopkeeper, who wants to use his list to send personalized emails.ДЄn Excel spreadsheet on your computer, with three customer names and their email addresses.

#Excel mail merge how to#

How to Send Personalized Mass Emails with Excel in Gmail (Step-by-Step Process)