background preloader

Create a Mail Merge with Gmail and Google Docs —

Create a Mail Merge with Gmail and Google Docs —
Learn how to create Mail Merge with Gmail and send personalized email messages in bulk. You may also add file attachments to the mass emails. Mail Merge for Gmail lets you send personalized email messages to multiple contacts in one go. The individual messages have almost the same content but some parts of the message can be customized. For instance, you can greet each recipient by their first name, you can include their postal address in the message body, personalize the subject line, attach different files while the other parts of the email body remain the same. Mail Merge in Gmail is for everyone. Here’s how you can do mail merge with Gmail: Install the Mail Merge for Gmail add-on. It is always a good idea to test your email campaign before sending a blast to multiple people. Gmail Mail Merge F.A.Q. Here are some answers to frequently asked questions around Mail Merge for Gmail and Google Apps: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. Mail Merge Support 19. 20.

Related:  Mail

ImportFeed in Google Docs Tutorial - Use Google Docs as an RSS Reader Learn how to use any Google Docs spreadsheet as an RSS Feed reader. You can also use the technique to embed RSS feeds into web pages. This tutorial shows how to use a spreadsheet in Google Docs as an RSS Feed reader. You can fetch RSS news feeds from different sources into one spreadsheet – much like a simpler version of Feedly – and then publish your feeds as a public web page. No coding required.

Tutorial: Automating a Help Desk Workflow - Google Apps Script function getColIndexByName(colName) { var sheet = SpreadsheetApp.getActiveSheet(); var numColumns = sheet.getLastColumn(); var row = sheet.getRange(1, 1, 1, numColumns).getValues(); for (i in row[0]) { var name = row[0][i]; if (name == colName) { return parseInt(i) + 1; } } return -1;} function emailStatusUpdates() { var sheet = SpreadsheetApp.getActiveSheet(); var row = sheet.getActiveRange().getRowIndex(); var userEmail = sheet.getRange(row, getColIndexByName("Contact email")).getValue(); var subject = "Helpdesk Ticket #" + row; var body = "We've updated the status of your ticket.\n\nStatus: " + sheet.getRange(row, getColIndexByName("Status")).getValue(); body += "\n\nNotes: " + sheet.getRange(row, getColIndexByName("Notes")).getValue(); body += "\n\nResolution: " + sheet.getRange(row, getColIndexByName("Resolution")).getValue(); // Create a vertical panel.. var panel = app.createVerticalPanel(); // ...and add the grid to the panel panel.add(grid);

Using ImportXML and XPath in Google Docs to Build a Web Page Monitor Learn how you can use Google Docs functions like ImportXML with XPath to build a web page monitor with scraping. This will help if you want to watch shopping sites like ebay or Amazon for any changes in the product price. RSS feeds have completely changed the way we consume information on the web. You no longer have to visit The New York Times or CNN every hour of the day to check news headlines because the feed reader is doing that for you behind the scenes. The only problem is that not all web content is available via feeds. For instance, Amazon, eBay and Google Product Search (Froggle) are good places to find discount deals on books and electronic gadgets but unfortunately, none of these shopping sites publish feeds.

Three Google Sheets Scripts That Help Teachers Save Time One of the great things about technology is that it can help use do things more efficiently which in turn means we get to spend more time on the more enjoyable parts of teaching, like working with students instead of working with paperwork. If you're a Google Apps user there are three Google Sheets (spreadsheets) scripts that I recommend trying. These scripts can help you save time on on sorting, grading, and assessing students' work. Flubaroo is an easy-to-use script that will grade multiple choice quizzes for you. You can even set-up the script to email all of your students their grades with just one click. Complete directions for using Flubaroo can be found here.

How to Create RSS Feeds for Google Searches This tutorial describes how you can create RSS feeds for Google search results of any query and then subscribe to search results in any feed Reader. Google Alerts, you probably know this, offer an easy way for you to create RSS feeds from the Google search results of any query. This is a good option if you are looking to monitor when new web pages are indexed by Google that match your search query. If you have never created feeds with Google Alerts earlier, here’s a quick primer. Type your search keyword, expand options, choose “Automatic” for sources, choose “All Results” for “How Many” and set “RSS Feed” as the Delivery Method. Google will create an RSS feed of web search results that you can subscribe in Feedly or another RSS Reader.

Interact with Websites via Easy to Remember Email Addresses 14 Aug 2008 You know how easy it is to interact with websites through email. For instance, you can upload photos to Flickr, publish blogs on Tumblr, upload files to Google Docs, save notes in Evernote, send videos to YouTube, convert documents .. and so much more with a simple email message. couch mode print story You know how easy it is to interact with websites through email. How to Use Flickr as a Photo Backup Service Flickr offers 1 TB of free storage space, 200x more than Dropbox or Google Drive, and this should be enough to backup your entire collection of photos online. Flickr, the original photo sharing service, now offers 1 Terabyte of free storage space and that should be enough to store your half a million photos securely in the cloud. Contrast this to Dropbox which offers 2 GB of storage space or Google Drive where you get 5 GB for your files and photos.

How to Email Web Pages to Yourself Learn how you can quickly email full web pages to yourself – the entire content – with a simple click. Great for reading web content offline. How do you email a web page – the entire content – to yourself? Your options vary depending on which browser you are using. If you are on Internet Explorer, there’s a handy “Send Page by E-Mail” option that you can use to send the full web page to anyone using your default email client.

Surf the Web via Email - Read Web Pages in your Inbox Web In Mail is a free email service that lets you surf websites in your Inbox. Send a blank email message and the full HTML web page will be delivered by email. If you work in an office where employees have no access to Internet but are allowed to send and receive email, the new Web-In-Mail service from Rediff will come very handy. All Email Messages in Gmail Have a Permanent Web Address 28 Jan 2009 Do you know that it is possible to bookmark individual email messages of Gmail just like you would bookmark any regular web page. couch mode print story To experiment, open any Gmail thread in your browser and notice the address bar as it gets updated with a unique URL. That’s the permanent address of your email message and it will stay the same as long as you don’t delete the message from your Gmail mailbox.

How to Quickly Compose a New Email Message 28 Jun 2013 Learn how to quickly compose a new mail message in your default email program directly from the address bar of any web browser. couch mode print story If you are to compose a new email message to someone, you’ll probably launch the mail program first, wait for the Inbox to load and will then hit the Compose button. That’s like 3 steps to open a blank new message. There’s a faster way though that will completely skip the Inbox.

Get a Temporary and Disposable Email Address with Outlook / Hotmail Don’t want to share your primary email address? You can create a temporary email addresses using Hotmail and share it without the risk of getting spam. A temporary email address is handy in situations where you don’t want to share your primary email address because of the risk of spam. Now there are quite a few services on the web, Mailinator and 10MinuteMail for example, that offer temporary email addresses for free but with certain limitations. For example, these services provide receive-only inboxes so you can’t send email to someone using your temporary address. Second, these addresses auto-expire after a certain time and then you may have to generate a new one. Most Contacted Email Addresses in Gmail 19 Dec 2009 Here’s how you can find the list of most contacted email addresses from your Gmail account: (adsbygoogle = window.adsbygoogle || []).push({}); Step 1. couch mode print story