How to Create Mail Merge in Gmail with Google Docs

How to Create Mail Merge in Gmail with Google Docs

Creating a mail merge in gmail is very simple. Creating a mail merge is the easiest way for sending out personalized mass emails. These mails are similar to the marketing mails sent by most companies.

SEE ALSO: How to Use Gmail Templates to Respond to Emails Faster.

In a mail merge, you inundate a template with information database. This database includes unique details and names.

You can use mail merge feature to send out company announcements, holiday newsletters and other official as well as personal messages. Sounds interesting? Then go ahead and try it.

Unlike the obsolete mail merges which were headaches in the past, Gmail can help you set up mail merge in no time. This way, you can send personalized mails to multiple people conveniently.

You can send personalized mails to multiple contacts in a single sitting with the mail merge in Gmail. There are a lot of additions that you can do in these messages.

For example, you can add each recipients name in their respective emails; this means that while the individual mails will have the same content, yet they will be personalized for every person they are sent to.  Other than names, you can also include postal address of the recipients, customize the subject line as well as attach files in the mail body.

The best part about mail merge is that, it is free. Let’s say, you are organizing a get-together at your home for your friends. You can use mail merge to send personal invites to your near and dear ones in one go.

If you own a business, then you can inform your esteemed customers about your upcoming offers and sales. In the corporate world, marketing and sales teams can use mail merge by Gmail for their drip campaigns.

Is this something that you could benefit from? Read on to find out how you can set up mail merge in Gmail.

Setting up Mail Merge in Gmail

The first thing that you need to understand is, your mail merge is set up with Google Documents.

  1. Select or create a Contact group on Gmail to which you want to send the mails to. You can also enter these names along with their email addresses into the mail merge spreadsheet directly.
  2. Select “Import Google Contacts” under the Mail Merge tab, next to the Help Tab. This will import all the contacts that you created earlier to the spreadsheet.
  3. The next step is creating the email messages which will be the templates for mail merge. You can either go for a simple, text only email message or choose to create a rich HTML mail, complete with pictures, audio or video. If you need to send an attachment along with your mail, you need to upload the same to your Google Drive.
  4. Click on “Insert File Attachments” for inserting the link of the file. Doing this will actually insert the file into the mail.
  5. You can also choose to do any other customizations to your wish.
  6. After you’re done, click on “Start Mail Merge” under the Mail Merge Tab.
  7. You will see that the “Configure Mail Merge” has changed to Mail Sent.

Google Docs will keep a log of all the mails which were sent.

A word of caution!

While the feature may seem pretty nifty, it is always advisable to test your campaign before sending out an email blast. You can do so very easily. Click on “Send a Test Email” under Configure Mail Merge tab. This way, the developer will get a sample email with dummy values. You can verify and check all the fields for errors and your mail is good to go!

How to Use WhatsApp to Store Your Photos, Documents and Notes Privately

How to Use WhatsApp to Store Your Photos, Documents and Notes Privately

Although quite a new entry into the tech valley, WhatsApp has solidified its presence amongst the tech giants. Having been bought by Facebook in 2014 for $19 Billion, the app already has proved its worth. The purchase of the app was the largest acquisition by the social media giant till date.

WhatsApp is multi-faceted. The developers keep releasing new features and functionalities with every new update.

The bonus is, there is a nifty hack that easily turns WhatsApp into your personal storage space. So, you can now use this cross-platform, end to end encrypted software securely to send yourself and store files, notes, audios and videos, besides a hoard of other stuff.

This handy feature is nothing like iMessage and other apps which are specific to texting. You can text yourself with WhatsApp, thereby saving all important stuff that you need to stash away.

The app allows you to search through your WhatsApp messages through keywords so it becomes really easy to search in your sent messages and save them for later use.

With this easy technique, you can also share documents from the desktop with yourself, instead of mailing them and then later downloading the attachments to use them. Easy, right?

Read on to find out how you use WhatsApp as a private storage!

The idea behind the hack is pretty simple. All you need to do is add yourself as a virtual contact inside the app and voila, you can share anything and everything with yourself. In normal circumstances, it is not possible to send any messages to your own number, but this handy hack allows you to do just that.

Here is how you can message yourself on WhatsApp:

  1. Open WhatsApp and create a new group.
  2. Give a name to your group when prompted by the app to do so.
  3. Add any contact from your address book. Name the group and save it.
  4. Go to your newly created group and click on the subject to view the list of people added in the group.
  5. Tap and hold to remove the other participant from the group.

Here’s how i created it. And this is only accessible to me.

That’s the end of it! You now have a secure, private storage on WhatsApp which is accessible and visible only to you. The best part? You can access this space both from desktop via and on your smartphone.

How to Use Gmail Templates to Respond to Emails Faster

How to Use Gmail Templates to Respond to Emails Faster

Google has emerged as the saviour for our busy selves in the modern era. Whether it is the maps or the app store or document editing in real life, Google offers all of it and for free!

SEE ALSO: How to Create Mail Merge in Gmail with Google Docs.

One such amazing service is Gmail. What started as a competitor to AOL and Yahoo has now turned as the biggest email service offered in the world.

Gmail has a clean interface with a lot of features to offer to its users. Writing the same mail repeatedly and forwarding it, could be a time consuming and frustrating task.

However, with Gmail templates, you can respond to emails faster and in a better way.

So, what are email templates and why should I use one?

In simple laymen terms, templates help you automate the process of sending the same redundant email all the time. This way, you type less and send responses fast.

All you need to do is set up an auto-response and save it; load it the next time you need to type an email.

While Gmail itself has automated templates called as canned responses, there are some other software too which help in making your work life easy.

Read on to find out!

Gmail Templates: Respond to mails in less than 60 seconds with Canned Responses

Gmail has inbuilt templates called as Canned Responses. All you have to do is to follow few simple steps and save them in Settings.

Sounds great! How do I go about it?

1. Click on the top right corner of your Gmail account.


2. Then click on Settings.


3. Go to Labs tab, scroll down and click enable under Canned Responses section.


4. Scroll down and click Save Changes. You’re done!

Creating a New Gmail Template

Now we’re going to create a new gmail template.

1. Click on the down arrow in the lower right corner of the new message window.


2. Then, click Canned responses > New canned response. Name the template as per your need; here i named it as “Thanks for your response”.


3. Add relevant body message and save it by clicking on desired template under save section of the canned responses. Here how i did it in my case.


Inserting the canned response in mailer body content

1. While composing a new mail, click on Canned responses in the menu and select the desired template under Insert.


2. Template is inserted. Fill in the “To:”fields. Custom edit the message if required and send. It might take some time getting used to, but you’ll thank this tip later. Trust me!


This template feature is in-built within Gmail. If you’re looking for some colorful and innovative templates, check out the services offered by third party extensions into Gmail or even creating one of your own.

Gmail Templates: Colorful, Unique and Vibrant Templates from cloudHQ

CloudHQ offers a Google extension which lets you insert predefined templates into your emails.

Follow these steps to have beautiful templates added to your emails:

  1. Add the Gmail Email Templates extension to your device from Google Store.
  2. After you add the extension, Go back to Gmail and click on Compose.
  3. Now click on Insert template, right next to Send.
  4. Now choose the message in the template you want to share with the clients and upload it.
  5. The template is now ready to be shared with your clients.
  6. Click Send once you see your message placed within the body of the email. You’re done.

Gmail Templates: Creating Custom HTML Templates with Publicate

If you want custom HTML email templates without any third party extensions try out Publicate. You can easily create custom HTML email templates in minutes, just by dragging and dropping. After signing up, all you need to do is to create the template in HTML format, save it and drag it on to your Template section right next to send option while you Compose an email.

I hope with these colourful and ready-to-use custom templates, you can respond to emails faster in Gmail. Happy working everybody!

5 Cool Shortcuts on Android Phone You’re Probably Not Using

5 Cool Shortcuts on Android Phone You’re Probably Not Using

Android operating systems have so much to offer in terms of functionality and ease of access. Along with a wide range of devices running over it, this versatility is what keeps the customer base loyal for android. Even without the flexibility of all the third party customizations, the android stock in itself is multifaceted and chalked full of useful tweaks and small features. Simplify your everyday smartphone usage with these shortcuts that you never knew existed.

Most of us know the usual shortcuts such as placing individual app on screen, using Home and Power buttons to turn the camera instantly; however, there is more to the resourceful Android.

Read on to find out what:

1. Searching for an app Quickly

For the digital life on the go, an android smart-phone means a hoard of apps installed for use. But, how to find a particular app in this sea? The answer is simple – Google Now Launcher! While being a stock launcher on Nexus devices, the app can be downloaded from Playstore for other phones too. Once installed, just long press on the app drawer icon which quickly converts to “Search Apps” bar.

2. Securing your Phone’s data with Encryption

You might be able to keep your phone safe from malware and virus with a robust anti-virus protection program, but what if you lose your set? Take the security on your phone one step further with data encryption. That’s right! Encrypt your data and secure it with a pin. Go to Settings>Security>Encrypt Device. In some sets, the same can be found under Privacy>Encrypt Device. Android has your back. In case of loss, the only way your phone can be restored is via a full factory reset.

3. Never miss another notification

It is so annoying when you accidently dismiss a crucial notification. Fortunately, you can access all your notifications with a single tap. Simply Hold the home screen and tap on “Widgets”. Scroll and add the “Settings” shortcut. Click “Notification Log” which will create a shortcut for the log on your Homescreen. Voila, all your notification logs are safe and sound!

4. Explain why you cannot pick calls – With a predefined message

In a meeting? Busy with a client? On a vacation? But cannot switch off your cell? We’ve all been there. Not to worry; because android lets you know your callers that you’re unavailable without picking up their calls.  This helpful yet unknown feature has been around since Android 4.0. Simply enable Quick Responses under Call Settings. The best part is you can customize your messages, or simply choose an already existing template available. Once enabled, a message will be sent to the caller when you reject their call. A word of caution though, the standard messaging charges from your network provider may apply.

5. Use your Voice to do things faster

Google Voice Assistant is perhaps one of the best hidden features available in your phone. Get things done quickly, find restaurants, call contacts and delete texts – all with your voice. Activate OK Google from Voice under Settings and you are good to go. With OK Google, you can control settings, perform general searches, use maps to navigate, take notes, set alarms and reminds besides doing other amazing things. It’s so much fun to be your phone’s commander, right?


While these are not all of the hidden features, the above list is more than enough to get you started and hooked. With all of these features, you will appreciate technology more. Perhaps, you will come up with a few hidden shortcuts on android yourself!

Awesome iOS 10 New and Updated Features You Should Know About

Awesome iOS 10 New and Updated Features You Should Know About

Major overhaul to iOS which was long overdue!

Apple released iOS 10 last year with some new and some updated features. It has received positive response from its valued customers largely so far. There are dozens of additional features besides improvements to some old ones. There are significant changes to major apps such as mail, notes, camera, photos, music, maps, iMessage and Safari.

iOS, packed with hidden functionalities, new features and integrations with third party apps, has a lot of hidden functionalities which can be explored.

Take a look at some of the awesome bells and whistles in iOS 10 here:

Multilingual keyboard support

QuickType now offers multilingual support and intelligent response. This means that you will receive suggestions in your typing language, without switching in that particular language’s keyboard. You will still need to add the keyboard to enable multilingual support though.

Incorporation of more emojis

Your chats are going to be more expressive now. iOS 10 is super emoji friendly, having included more than a 100 new emojis in this update. These have a number of gender options to already existing emojis. Popular emojis and family emojis have also been redesigned. The new emojis are thrice as big as their previous counterparts.

Channelize your sleep

iOS 10 can help you channelize your sleep cycle. Bedtime is a new tab in Clock app which encourages you to get a good night’s rest. The feature keeps track of your sleep cycle for maintaining a consistent and fulfilling sleep schedule. You can choose the number of hours you want to sleep and at what time you want to wake up. This is incredibly helpful for those of us who have trouble getting up and going to bed.

Music and Camera together on the go

Before iOS 10, it was impossible to take pictures while playing music. With iOS 10, playback does not stop all of a sudden. Take party selfies without stopping the sweet sounds of music.

Control of flashlight intensity

With iOS 10, you can change the flashlight intensity to avoid sudden blinding lights. You can select between high, medium and low intensities to adjust. The settings can be changed in the Control Centre but are not adjustable in iPhones without 3D Touch.

Use Camera as Magnifying Glass

iOS 10 features another handy functionality – you can use its camera as a magnifying glass. You can activate the magnifier by triple tapping on the Home Button after controlling the magnifier accessibility in General Settings. Reading small prints has never been this easy!

Lyrics in the Music App

The music app now has lyrics which appear while the song is being played. Just scroll down to the now playing section to see them below the audio controls. While most of the songs have lyrics displayed, if you cannot see them, they have not been added yet.

“For you” news section and news notifications

The ‘For you’ section of the News App has been updated. The new iOS 10 news app is more personalized. The news reading app has a better design and better selection of trends, topics, features and stories based on your liking.

Another great news feature is that you can now read stories quickly from your favourite news channels via notifications. This section is customizable. Just edit the “Favourites” section of Apple news which can be accessed by tapping on the bell icon on top left.

Removal of Stock apps

You can remove some stock apps in iOS 10. Just tap and hold on the app icon to see the cross button. You can also reinstall an app you removed by mistake from iTunes.

Integration of Siri with third party developer apps

With iOS 10, Apple has made Siri available to the iOS app developers. With Siri’s help, you can develop more inside apps. Your favourite apps can now communicate with Siri to search for photos, send messages, place calls, make payments, start workouts and book rides. They are all a voice note away!

Turning individual receipts on and off

You can finally toggle read receipts on or off on individual basis in iOS 10. This is a welcome change from the previous versions of iOS where you could either turn off the receipts completely or apply to all your contacts. All you need to do is tap the “i” icon on the top of any conversation. It will then display a new Send read receipts which you can toggle on or off. This, however, works only with iMessage threads and not the standard SMS facility.

Unsubscribe from mailing lists quickly

Apple has introduced an unsubscribe link for emails which come from mailing lists. The feature scans the message for any mention of unsubscribe from your mails. Once you tap on the Blue Shortcut link, you can confirm on the pop-up and you will be no longer subscribed to the mailing list. This is pretty handy for all the spam mails that one receives in the inbox.

Toggle text between multiple devices

iOS 10 has introduced a new feature called as Universal Keyboard. This lets you copy something on one of your Apple devices and paste on another device as long as you’re signed in with the same Apple ID on both the devices. The copy and paste work is pretty much in the background or invisible and there is no extra menu as such. You can access the copy and paste menu options as you normally would.


iOS clearly has a lot to offer. With better performance, user-friendly apps and Siri’s integrations to third party apps, the tech giant Apple is all set on increasing the popularity of its devices further among users.

How to Download Email Addresses and Phone Numbers of all your Facebook Friends

How to Download Email Addresses and Phone Numbers of all your Facebook Friends

For some good reasons, a lot of people would love to communicate with contacts outside of Facebook. Though Facebook is a good place for communication, it’s still a good idea to have full control of who to contact and on what platform to do so.

SEE ALSO: How to Use WhatsApp to Store Your Photos, Documents and Notes Privately.

With a full list of email addresses of all Facebook contact, it is also possible to have everyone in different categories for essential bulk messages to all. This is obviously not possible on Facebook except by a group chat which rules out privacy between individuals as mail would so do.

With Facebook privacy settings, users can hide their email address. In this case, Facebook doesn’t show the emails instead Facebook uses its own format and email address looks like or The email address provided by Facebook depends on username.

Here is a very easy step by step approach to exporting all email addresses available in any Facebook account.

1. Login to your Yahoo mail or create one if you don’t have.

2. On the top left – click Contacts.

3. In Import Contacts, choose Facebook as Import.

4. A separate Facebook window opens, which you need to login with your Facebook login id and password.

5. This will make your Yahoo mail account to access your Facebook and automatically import your facebook friends email addresses.

6. Click Actions on the top and Export.

7. Select Yahoo CSV and click Export Now.

That’s it. Save to your computer. You can even import this CSV file into your phone address book, Gmail contacts, LinkedIn or any other social sites where you want to connect with your existing Facebook circle.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from Tech Amaze

You have Successfully Subscribed!

Pin It on Pinterest