HOW TO SEND ONE MESSAGE TO MULTIPLE E-MAIL ADDRESSES (BULK E-MAILS)



First, you’ll need a computer, good connection to the internet, then, have all email addresses you would like to send message(s) to, ready.

1. GMAIL ACCOUNT

  • Create a gmail account or log-in to your already existing account.
  • Click on Compose to start a message with a subject name.
  • Save the message to draft.

2. GOOGLE DRIVE

Click on the google apps icon close to your profile photo on the top-right corner of your computer screen.
  • Select/hit on drive.
  • Hit on the button that says “New.”
  • Select Google Sheet (you may need a little knowledge of MsExcel to be able to work with the sheet).
In the opened google sheet, you may want to write a title on the untitled single column at the top left side directly above the displayed menu.

3. COPY EMAIL ADDRESSES

Leave the page (google sheet) and go copy the email addresses you want to send message to, or click ‘File’ on the top menu and select import to get the addresses if you already have it saved in MsExcel.
Email addresses should be imported to or paste on Google Sheet starting from Cell A2 downwards. Cell A1 should be left for headings. Example “Email_Address, Names etc.”


Zoom to use image as guide

4. USE YET ANOTHER MAIL MERGE

Locate ‘Add-ons’ on the same google sheet’s top menu and click on it. If you don’t already have Yet Another Mail Merge, click Get Add-ons before you can use it. (Using its free plan will only allow 50 free emails to be sent per day while its paid personal plan which cost $24 allows 400 emails per day).
But, if you have it already, select:
  • Start Mail Merge.
  • Click on continue.
  • Wait a little.
You may be asked to select your preferred gmail account if you have more than one.
  • Scroll down to click on allow and wait for it to load.
  • Hit on continue.



You will be presented with a pup-pu that looks like the above image for you to:
  • Type in sender’s name.
  • Locate Email Template on the screen and select the message to be sent from your gmail draft.
  • Tick the Track Emails Opened checkbox.
  • Hit send button and OK button.

Comments

Post a Comment

Popular posts from this blog

Mouse and Keyboard Techniques

Image
Mouse and keyboard are the most common input devices used to instruct the computer which is why learning mouse and keyboard techniques is essential. The mouse is a hand operated device used to interact with files and to manipulate objects on the computer screen. MOUSE DESCRIPTION The mouse comprises of clickable buttons that users can right-click and left-click to carry out important computer functions. It has USB or PS/2 cord that enables its connection to the mother-board via the computer ports. Also, there are wireless mouse with Bluetooth technology. Mouse comes in different colors and shapes and can fit into the right and the left hands of any user. Bluetooth mouse  MOUSE TECHNIQUES There are four basic mouse techniques. Clicking  Double Clicking  Drag  Point  KEYBOARD The computer keyboard which is modelled after typewriter-style is used to input data into the computer. There are different types of computer keyboard with differen...
Read more

Computer Keyboard Shortcut Keys

Image
This post focuses on Windows, Microsoft Word, CorelDRAW and Web Browser shortcut. Windows and Microsoft Word Shortcuts Alt + F4 To close active window(s) and to perform computer shutdown. Alt + F For menu options in current program. Alt + Tab To switch between tabs. Ctrl + A To highlight all items in an document or page. Ctrl + B To bold highlighted texts. Ctrl + C To copy selected items. Ctrl + F To find word(s). Ctrl + I To italic highlighted texts. Ctrl + N To start a new page. Ctrl + O To open existing document. Ctrl + S To save current document. Ctrl + U To underline highlighted text. Ctrl + V To paste copied items. Ctrl + X To cut selected items. Ctrl + Y To redo action. Ctrl + Z To undo action. Ctrl + End To go to the end of a document. Ctrl + Home To go to the beginning of a document. Ctrl + Alt + Del To open task manager. Ctrl + Shift + C To copy formatted texts. Ctrl ...
Read more

Web Browser Shortcuts

Image
What is a Web Browser? A web browser or internet browser is commonly referred to as a browser. It is a software application for exploring information on the World Wide Web. There are lots of web browsers out there but this post will cover shortcuts of these popular browsers; Chrome, Firefox, Safari, Explorer and Opera Mini. Note: while most shortcuts on this post are general to Google Chrome, to some browsers, the shortcuts may not have similar functions or does not function at all.  Shortcuts Keyboard Keys Functions Browser Alt Opens Menu. Not general Alt + D Highlights the URL on the browser bar. General Alt + ← To previous web page (back). General Alt + → To previous web page (forward). General Ctrl and click on a link Opens link in a new tap. Not general Ctrl + D Adds to bookmark. General Ctrl + E Place console in search area. General Ctrl + H History General Ctrl + I Has different functions to d...
Read more