You will learn how to create a spreadsheet with contact information.You can use a mail merge add-on to convert contact info in a spreadsheet into a mailing list and then send an email using Gmail.The daily sending limit is 500 emails.
Step 1: You can navigate to the site using a web browser.
On PC or Mac, you can use any web browser.This is the address of the website.
Step 2: You can click.
The icon has three horizontal lines in the upper- left corner.The menu is displayed to the left.
Step 3: Click the sheets to open them.
When you click the icon with three horizontal lines, it flies out of the menu.It's next to an icon that looks like a green sheet of paper with a table.This spreadsheet opens in a word processor.
Step 4: You can click Blank.
The first square at the top of the page has an icon that looks like a plus sign.A new document is created by this.
Step 5: Click on the add-ons you wish to add.
The menu bar is at the top of the website.A drop-down menu is displayed.
Step 6: You can get add-ons.
It can be found in the drop-down menu.You can use this window to search for and install add-ons.
Step 7: In the search bar, type Mail and press Enter.
The search bar can be found in the upper-right corner of the window.There is a list of Mail Merge add-ons.
Step 8: Next to "yet another mail merge" you can click and free.
There is a blue button to the right of the add-on.It has a red icon that looks like an envelope with a rocket under it.You can send up to 50 emails per day with a free version of " Yet Another Mail Merge".You can send up to 400 emails per day with a personal plan.You can install other mail merge add-ons.You can try different ones to see which one you like the best.
Step 9: Go to your primary account.
The add-on displays a list of accounts.Click the account you want to grant access to.If you don't see the account you want to use, click and sign in with your email and password.
Step 10: Click Allow if you want to proceed.
There is a blue button at the bottom of the page.
Step 11: You can use a web browser to navigate to the website.
On PC or Mac, you can use any web browser.This is the address of the website.
Step 12: Click on it.
The icon has three horizontal lines in the upper- left corner.This shows the menu.
Step 13: Click to view the sheets.
When you click the icon with three horizontal lines, it flies out of the menu.It's next to an icon that looks like a green sheet of paper with a table.This spreadsheet opens in a word processor.
Step 14: Click on the blank area.
The first square at the top of the page has an icon that looks like a plus sign.A new document is created by this.
Step 15: Send your contact information in the form of a Headers.
The first row at the top of the spreadsheet is where you should put your contact information.In the first two cells you can create a column with your contacts first and last names.To create a column for your contacts email addresses, you need to type in a cell at the top of the spreadsheet.If you have other information, such as and, you can create a headers for it.
Step 16: Please enter your contact information below.
The first and last columns contain the contact's name.They should type their email in the column.You can add any other contact information in the columns below.You can import contact information by clicking on it.Select and then select again.Use the drop-down menu to select a contact group.
Step 17: You can use a web browser to navigate to this site.
On PC or Mac, you can use any web browser.There is a website for Gmail.If you don't have a Gmail account, you can sign in with your email address and password.
Step 18: Click it to write.
It is in the upper left corner of the website.There is a white button with a colorful sign.
Step 19: The "Recipients" line should not be drawn.
You don't need to enter anything in this line.The Yet Another Mail Merger add-on will fill this line.
Step 20: A subject is what you should type.
To type a subject for your email, use the "Subject" line.
Step 21: To type a message, use your fingers.
You can type the message you want to send in your spreadsheet.Every minute or so, Gmail saves your email as a draft.In your email message, you can type $%[Header]% to pull information from your spreadsheet.If you wanted to address the recipient by their first name, you would type "Hello $%First%" in the email message.The contacts name will be pulled from the email.
Step 22: You can use a web browser to navigate.
On PC or Mac, you can use any web browser.This is the address of the website.
Step 23: Click if you want to.
The icon has three horizontal lines in the upper- left corner.This shows the menu.
Step 24: You can click on the sheets.
When you click the icon with three horizontal lines, it flies out of the menu.It's next to an icon that looks like a green sheet of paper with a table.This spreadsheet opens in a word processor.
Step 25: The spreadsheet has your contact information.
Click on the document in the list to open the spreadsheet.
Step 26: Click Add-ons.
The menu bar is at the top of the page.
Step 27: You can click yet another mail.
There is a sub-menu for Yet Another Mail Merge.
Step 28: Go to Start Mail Merge.
The Yet Another Mail Merge sub-menu has it at the top.
Step 29: Click Continue.
There is a blue button in the middle of the page.You can use the free version of Yet Another Mail Merge to send 50 emails per day, according to the pop-up window.You can send 400 emails per day with the Personal Plan.
Step 30: Write your name on the piece of paper.
To type your name, use the line next to sender name.
Step 31: Select the email template you want to use.
Click the drop-down menu next to "Email template" and select the email template you created for your mail merge in Gmail from the list of email templates.
Step 32: You can click to send emails.
There is a blue button in the lower left corner of the window.You can use this to send an email to all the email addresses below your "Email" address.There is a tracking report on the right.There is a number of emails displayed in the "Send # Emails".Before sending an email to everyone in your spreadsheet, you should send yourself a test email.