This wikiHow teaches you how to create a spreadsheet with contact information through Google Docs. You can use the mail merge add-on in Google Docs to convert the contact information on a spreadsheet in a document to a mailing list, then send the email using Gmail. However, Gmail has an email limit of (maximum) 500 messages per day.
Step
Part 1 of 4: Installing " Yet Another Mail Merge " Add-on
Step 1. Visit https://docs.google.com via a web browser
You can use any browser on your PC or Mac computer. The address is the web address of the Google Docs service.
Step 2. Click
It's an icon with three horizontal lines in the upper-left corner of the page. The menu will load on the left side of the page after that.
Step 3. Click Sheets
This option is in the menu that appears when you click the three horizontal lines icon. You can see it next to the icon of a green sheet of paper with a table. The spreadsheet will open in Google Docs.
Step 4. Click Blank
This option is the first box to have a colorful plus sign (“+”) icon at the top of the page. A new Google spreadsheet document will open.
Step 5. Click Add-ons
This option is in the menu bar at the top of the site. A drop-down menu will appear after that.
Step 6. Click Get Add-ons
This option is in the drop-down menu under "Add-ons". A new window will appear and you can use it to search for and install add-ons.
Step 7. Type Mail Merge into the search bar and press Enter
It's in the upper-right corner of the window. A list of mail merge add-ons will be displayed.
Step 8. Click + Free next to " Yet Another Mail Merge"
It's a blue button to the right of the add-on called " Yet Another Mail Merge ". This add-on is marked by a red envelope icon with a rocket underneath.
- The free version of " Yet Another Mail Merge " allows you to send a maximum of 50 messages per day. The personal package/quota is offered at a price of 24 US dollars (approximately 350 thousand rupiah) per year and allows you to send a maximum of 400 messages per day.
- There are a variety of other mail merge add-ons you can install. Try different options to see which add-on you like best.
Step 9. Select the primary Google account
When adding add-ons, a list of Google accounts stored in the browser will be displayed. Click the Google account whose access you want to give the add-on.
If you don't see the account you want to use, click “ Use another account ” and log in using the account email address and password.
Step 10. Scroll down and click Allow
It's a blue button at the bottom of the page in the window that opens.
Part 2 of 4: Creating a Spreadsheet with Contact Information
Step 1. Visit https://docs.google.com via a web browser
You can use any browser on your PC or Mac computer. The address is the web address of the Google Docs service.
Step 2. Click
It's an icon with three horizontal lines in the upper-left corner of the page. The menu will be displayed afterwards.
Step 3. Click Sheets
This option is in the menu that appears when you click the three horizontal lines icon. You can see it next to the icon of a green sheet of paper with a table. The spreadsheet will open in Google Docs.
Step 4. Click Blank
This option is the first box to have a colorful plus sign (“+”) icon at the top of the page. A new Google spreadsheet document will open.
Step 5. Create a header segment for contact information
Use the first row above the spreadsheet to create the contact information headers in each box. Type " First name" and " Last name ” in the first two boxes in the row to create a column containing the contact's first name and last name. After that, type " Email address ” in the next box at the top of the spreadsheet to create an email address column. You can also create headers for other available information, such as “ Phone number" and " City" or " Address ”.
Step 6. Enter the contact information under the header or in the appropriate fields
Type the contact's name into the box below the "First name" and "Last name" headers. After that, enter the contact's email address under the "Email address" header. Add other contact information in the field under the appropriate header/title.
You can also import contact information by clicking “ Add-ons " and choose " Yet Another Mail Merge " Choose " Import Contacts " and click " Google Contacts " or " Other CRMs " Specify a contact group using the drop-down menu next to “Groups”, then click “ Import Contacts ”.
Part 3 of 4: Creating Email Templates
Step 1. Visit https://mail.google.com via a web browser
You can use any browser on your PC or Mac computer. This address is the Gmail website address.
If you are not logged into your account, click the desired Gmail account or select “ Use another account ” and log in using the account email address and password.
Step 2. Click Compose
It's in the top-left corner of the Gmail website. This white button has a colorful plus sign (“+”).
Step 3. Leave the "Recipients" field blank
You do not need to enter anything in this field. This field will later be filled with information from the “Yet Another Mail Merger” add-on.
Step 4. Type in the title/subject of the email
Use the " Subject " field to enter the subject of the email you want to send using the contact list from the spreadsheet.
Step 5. Type in a message
Enter the message you want to send to contacts from the spreadsheet. Gmail will automatically save your email as a draft every minute or so.
You can retrieve information from a spreadsheet by typing $%[Head]% into the email. For example, if you want to greet the recipient by their first name, type Hello $%Firstname% into the main body of the message. The contact's first name information will be retrieved from the spreadsheet and added to the email
Part 4 of 4: Using Other Mail Merge Features to Create a Mailing List
Step 1. Visit https://docs.google.com via a web browser
You can use any browser on your PC or Mac computer. The address is the web address of the Google Docs service.
Step 2. Click
It's an icon with three horizontal lines in the upper-left corner of the page. The menu will be displayed afterwards.
Step 3. Click Sheets
This option is in the menu that appears when you click the three horizontal lines icon. You can see it next to the icon of a green sheet of paper with a table. The spreadsheet will open in Google Docs.
Step 4. Click the spreadsheet that contains the contact information
To open a spreadsheet, click the document in the spreadsheet list.
Step 5. Click Add-ons
This option is in the menu bar at the top of the web page.
Step 6. Click Yet Another Mail Merge
The submenu for the “Yet Another Mail Merge” add-on will open.
Step 7. Click Start Mail Merge
It's at the top of the “Yet Another Mail Merge” submenu.
Step 8. Click Continue
It's a blue button at the top of the window, in the middle of the page. A pop-up window will appear informing you that you can send up to 50 emails per day using the free version “Yet Another Mail Merge”. However, the personal plan/quota is offered at a price of 24 US dollars (approximately 350 thousand rupiah) per year and allows you to send a maximum of 400 emails per day.
Step 9. Type in your name
Use the field next to "Sender Name" to enter your name.
Step 10. Choose an email template that has been created
Click the drop-down menu next to "Email Templates" and select an email template that has been created for mail merge in Gmail in the list of templates.
Step 11. Click Send # Emails
It's a blue button in the lower-left corner of the window. Messages will be sent to all email addresses under the " Email " heading, using the email template you selected. You can see the tracking report on the right side of the page.
- The "#" symbol on the "Send # Emails" button displays the number of emails you will send.
- Click " Receive a Test Email ” to send yourself a test email before you send it to everyone on the spreadsheet.