How to Create Mail merge using Gmail with Spreadsheets

Loading...

MADE STUFF EASY HOW TO



IOS / MAC



WINDOWS



ANDROID



INTERNET



SECURITY



DEALS

SUBSCRIBE TO BLOG VIA EMAIL

You are here: Home / How To / How to Create Mail merge using Gmail with Spreadsheets

How to Create Mail merge using Gmail with Spreadsheets In this tutorial, you will see how to create a mail merge using Gmail in spreadsheets. Although there are many other possible ways to create a mail merge using Gmail, here you will see the best and

Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 45 other subscribers

easiest way to create mail merge which I personally prefer. Using mail merge now becomes important a lot especially to those who are running big companies and those who have a number of people connected to them. SUBSCRIBE

RECENT POSTS MacPaw CleanMyPC Review: Best PC Cleaning Software DesignEvo Review: Best Free Online Logo Design Tool Photomatix Pro Review 2018: HDR Photography ExpressVPN Review 2018: Best Way to Remain Anonymous Online Panda Security Review 2018: All about Panda Internet Security

What is Mail Merge?

SEARCH MADE STUFF EASY

Before we begin, let us know what mail merge exactly is? Let us consider an example suppose if school teacher has to give assignments to the students then, he can manage to send the same email to everyone without sending them individually using mail merge or if a company wants to send the information to their employees then he manages to send an email to everyone with mail merge.

SOCIAL

Must Read: What is Phishing and how to protect against Phishing threats?

How to Create Mail merge using Gmail with Spreadsheets STEP 1: Open your Gmail account and Sign in with your login credentials. Now Tap on the Google apps icon on the top right side of your screen (see below screenshot if unable to identify).

STEP 2: Now select Drive app from the drop down apps list. You can also choose Docs in more apps option, (but here in this tutorial we are using spreadsheets option to create mail merge).

STEP 3: After Spreadsheet opens tap NEW, Change its name (here I have renamed it as My Mail Merge), you can choose according to you.

STEP 4: Now write down the details you want to list in a spreadsheet. I have marked as Name, Age, Place, Email Address. You can write according to your criteria. See STEP 5 if you want automatically to attach names, address and other details you have in your Google Account.

STEP 5: Now tap over to Add-ons> Get Add-ons. Now search for new add-ons Yet Another Mail Merge. This add-on is free of cost and easy to use. By using Yet Another Mail Merge you can easily add automatically names, contact, the email address that you already have in your Google Contacts.

STEP 6: Now go back to Gmail account you have logged in in STEP 1. Now create a new Draft there and save it. If you want to send an email with specific names or address to a specific individual then must write as $%name/location%. If you are unable to understand this you must see below screenshot to make it clear. Save this draft. Do not write anything in the field of Recipients. Left it as blank. Must see: How to create Gmail signature

STEP 7: Then again go to the spreadsheet you have created and navigate to Add-ons> Yet Another Mail Merge> Start Mail Merge. Click continue if option displays. NOTE: If you are using free version then you can send mail to 50 Recipient only. You can buy a package or one free option is to invite your friends to exceed your daily limit of sending emails. For this, a Dialogue box will appear otherwise select continue for next step. STEP 8: Now a dialogue box will appear (as shown in below screenshot), You can edit Senders Name (Your Name) and select Email Template as the subject you have written in Saved Draft earlier in STEP 6 ( I have written Hi $%NAME%). Now tap Send 4 Mail ( here I have 4 email address).

STEP 9: Your email successfully sent to the address you provided, but still you can send an email to 46 other members as total free quota limit up to 50 Emails a day. It will show you Merge Status in next column of your detail once you send emails.

After following these steps you can easily create a mail merge. Let us show you how it appears to the receiver, the email you have sent.

Check out the name, age and place automatically appear by using the text as discussed in STEP 8. You need not have to write the individual name as it consumes your time a lot.

Comments No Doubt Mail Merge with Gmail is the best option. You can have a daily limit of 50 Recipients, but if you want to exceed this limit you have to buy plans according to your need or daily email usage. You may also like: How to sync desktop PC with Google Drive and Google Photo How to download Google Maps offline navigation on iPhone and Android I hope you like this tutorial about How to create a Mail Merge using Gmail in spreadsheets. Please share it with your friends so that they can also access mail merge easily with few simple steps. Keep in touch with us for more useful information on social media Facebook, Twitter, and Google+.

Share this:

19

LEAVE A REPLY Your email address will not be published. Required fields are marked * Comment

Name *

Email *

Website

POST COMMENT

Notify me of follow-up comments by email. Notify me of new posts by email.

© 2017 · madestuffeasy.com · Privacy Policy · Disclaimer · Sitemap · About · Contact

Loading...

How to Create Mail merge using Gmail with Spreadsheets

MADE STUFF EASY HOW TO IOS / MAC WINDOWS ANDROID INTERNET SECURITY DEALS SUBSCRIBE TO BLOG VIA EMAIL You are here: Home / Ho...

962KB Sizes 2 Downloads 12 Views

Recommend Documents

How to create a mail merge in Gmail | ITProPortal
May 12, 2015 - In this short tutorial I will explain how to do a mail merge in one of the world's most popular free emai

How to create an E-mail Merge using Microsoft Outlook
How to create an E-mail Merge using Microsoft Outlook 2007. *Note: Unlike earlier versions ... In the “Start Mail Merg

How to create a mail merge
Click on Mail merge wizard. Notice that the mail merge task pane is on the right side of the screen. The mail merge wiz

How to Send Personalized Emails with Mail Merge for Gmail
Sep 27, 2017 - Learn how to send personalized email messages in bulk using mail merge in Gmail and Google Inbox. You can

How to Create a Mail Merge Document Using Microsoft Word
Sep 8, 2011 - Mail Merge mass produces letters, mailing labels or other documents. To perform a mail merge you need two

How to create mail merge documents with Pages and Numbers
Jan 5, 2015 - numbers mail merge. In Numbers, create a spreadsheet that includes the data you want to merge. Launch the

How to Create Mail Merge in Gmail with Google Docs - Digital Inspiration
Sep 27, 2017 - Under the Mail Merge menu, choose Import Google Contacts and select the Google Contacts group that you cr

Send Personalized Emails Using Mail Merge with Gmail | SalesHandy
Sep 29, 2017 - We have all been there. Wanting to send emails in bulk but afraid of showing that you sent the same email

How can I create mail merge documents using Zoho Writer?
Create Mail Merge Documents. Creating mail merge documents using Zoho Writer involves three steps: Create Mail Merge Tem

How To Use Yesware's Mail Merge for Gmail - Yesware Blog
Below, we walk through the creation of a 3-step Gmail campaign for new leads. As you read, keep in mind that Mail Merge