Friday 10 March 2017

How to Email Unique File Attachments using Mail Merge for Gmail

Mail Merge, available for Gmail and Google Inbox, is a perfect tool for sending personalized emails to one or more email addresses using a simple Google Sheet. If you never performed merge before, please watch the Mail Merge tutorial and documentation to get started.

One of the most popular features of Mail Merge is its unique ability to send different file attachments to different email address. For instance, if you are applying for a job at different companies, you can attach the same PDF resume in all email messages but the cover letter could be different with each application.

This step-by-step tutorial explains how you can you can use Mail Merge for Gmail to send unique email attachments to your contacts. Mail Merge pulls files from Google Drive and includes them as attachments in the outgoing email messages.

Steps :-

Step 1: Install the Mail Merge add-on.

Step 2: Open a new Google Sheet, go to Addons > Mail Merge with Attachments > Create Merge template to initialize the sheet.

Step 3: Add one or more rows in the Mail Merge sheet. To keep things simple, you can add the First Name, last Name, and the Email address as shown in the screenshot.



Attach Google Drive files to Mail Merge-

Step 4:  Go to Addons > Mail Merge > Add File Attachments > Insert Files from Google Drive and select one or more files that you wish to send with your email message. You can also select the option Select Files from Computer if the files are on the computer.

Mail Merge will get the direct link of the selected file(s) and inserts them into the File Attachments column. If you wish to send more files with the same email message, you can add the drive links in the same cell, separated by the comma.

Easily Add File Attachments with Mail Merge-

In the previous step, we used the Google File Picker to select the files from Google Drive. This is slightly tedious more so as you have to repeat the steps for every row in your Mail merge sheet.

There’s an easier way though for adding attachments to merge. Instead of using the File Picker, you can simply put the name of the file in the File Attachments column. The addon, at the time of sending the email, will search your Drive for that file and attach it to the email message.

If you have multiple files in Google Drive with the same name, you can specify the folder path where the file is located. The syntax is \\Folder A\\Folder B\\filename.ext

I want to show you one more technique for quickly attaching files to your Mail mere sheet. Go to Addons > Mail Merge > Add File Attachments > List Files in Google Drive Folder. Now select the parent folder in your Google Drive and the addon will generate a list of every file it found inside that folder, including sub-folders.

Now switch back to the Mail Merge sheet and you’ll notice that a drop-down has been added to every cell in the File Attachments column. This makes it even easier for you to select files from Drive.

So we are all set. Go to the mail merge menu, choose Configure and run merge (video) to send your emails that all have unique attachments. You’ll find a copy of the emails in your Gmail Sent items.

Enjoy.!! 

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Labels

404 AdBlock Add-on Airtel GPRS Trick Airtel SMS Trick Alexa Amazon Amazon Kindle Amazon Prime Android Android 8 Android Oreo antivirus Apple Apple Mac ASCII Audacity Audio Authotkey Backup Balance Transfer in Vodafone Battery Bing Blogger Blogging Bookmarklet Browser Camera Chromebook clock Cloud colors command lines Computer Computer Tricks configuration Contact Creative Commons Credit Card CSS devolop DIY Doodle DOS Download Dropbox E-Mail eBook Email Email Attachment Embed Encryption English Error Evernote Eyes Facebook Facebook Tricks Feedburner Flipkart Font Foursquare Free Internet Free sms trick in Vodafone G Mail Gadget Game Getty Images GIF Gists Github Google Google AdSense Google Analytics Google Apps Google Chrome Google Contacts Google Currents Google DNS Google Docs Google Drive Google Earth Google Font Google Forms Google Images Google Map Google Photos Google Play Store Google Plus Google Print Google Reader Google Script Google Sheets Google Spreadsheet Google Translate GPRS Setting GPS Hacking Health App HelloFax Hindi Hoodie HTML Icons idea Image Editing Images IMEI Indian Railways Infographics Instagram Internet Internet Explorer Internet Tricks iOS iPad iPhone IRCTC iTunes iTV JavaScript JioCinema JioTV Junglee Kindle Language Translation Laptop Laptop. TV Life Time FREE GPRS Life-Style Link Linkedln Linux logo Make Money Online Microdoft Powerpoint Microdoft Word Microsoft Office Microsoft Outlook Mobile Mosaic Music Name Networking nexus Notepad OCR Online Shopping Open DNS OS Outlook Password PDF Petya Phillips Hue Lights Photogtraphy Pixel Play Station Podcasts Pokemon Pokemon Go Polls Print Productivity Proxy Server Pushbullet QR Code Ransomware Reddit Reliance Hack GPRS Reliance Jio RGB Ringtone Router RSS Safe Mode Samsung Galaxy S Scrabble Screen Capture Screen Sharing Screencast Secrets Security Send free sms from PC SEO Sierra Skype Slideshare SMBv1 SMS Snapchat Snapdeal Social Media Solution Sound Device Speech Recognition Sql Steam Sync Synology NAS Tata Docomo GPRS trick Teleprompter Torrent Trick Tricks TV Twitter UltraISO Unicode Unknown Extension Unlimited 2GB Unlimited 3GB Unlimited GPRS USB USB Security Key Video Editing virtual desktop Virus attack VLC Vodafone 110% working trick for GPRS Vodafone 3g Vodafone GPRS VPN wallpapers WannaCry Web Design Web Domain Website Wget Whatsapp WiFi Wikipedia Windows Windows 10 Windows 10 S Windows KN Windows Tricks windows updates Winows N Wolfarm Alpha WordPress XBox YouTube Zip
Twitter Delicious Facebook Digg Stumbleupon Favorites More