How to send bulk emails with different attachments? (Mail Merge in Gmail)

What is Mail Merge?
Mail Merge is very interesting and powerful method of Word Processing tool like MS Word which is used to create personalized letters, labels & name tags etc using the data from spreadsheets(excel files), tables of databases.
For example, if you need to send Letter of Appreciation to 100 numbers of your employees. In this case your letter format is same for all but the data like name of employee, employee id, designation etc will be different for each employee. So, by using Mail Merge facility we only need to create the format of letter once and then we can import and merge the data of employees from excel file or database tables and generate 100 personalized letters for each employee in few easy steps in few seconds.

What is Mail Merge in Gmail with Attachments?
Mail Merge facility in gmail is used to send bulk emails having personalized message body and different attachment files for each email.
For example, if you need to send 200 numbers of personalized email to your students sharing their grade sheets. In this case, the email format is same for all students except the name of students, roll number, email id and the grade sheet in pdf files. So, by using Mail Merge facility in Gmail we only need to import the data from excel files or database tables to google spread sheets, the pdf files in google drive and creating the email message format only once. After that in very few easy steps, personalized emails with attachments can be sent to all the students in no time.

Please go through the below video link for complete demonstration for using Mail Merge in Gmail with Attachments :

Blogger Name: Pramod Kumar Kushwaha
For more information & feedback write email at :

इस ब्लॉग से लोकप्रिय पोस्ट

कश्मीर : धरती का स्वर्ग (Trip to Kashmir : Paradise on Earth - Hindi Blog)

मालवण : सिंधुदुर्ग की शान ( Trip to Malvan - Hindi Blog )

महाबलेश्वर और पंचगनी : एक प्यारा सा हिल स्टेशन (Trip to Mahabaleshwar & Panchgani - Hindi Blog)

श्रीनगर : एक खूबसूरत शाम डल झील के नाम (A Memorable Evening in Dal Lake Srinagar - Hindi Blog)

समुद्र में मोती : अंडमान निकोबार द्वीप समूह की यात्रा (Andaman Trip - Hindi Blog)

चित्रकूट : जहाँ कण कण में बसे हैं श्रीराम (Trip to Chitrakoot - Hindi Blog)

पालखी : पंढरपुर की धार्मिक यात्रा(Palkhi Yatra to Pandharpur - Hindi Blog)

प्राचीन गुफाओं और मंदिरों का शहर : बादामी, पट्टदकल और ऐहोले (Trip to Badami, Pattadkal & Aihole - Hindi Blog)

कास पठार : महाराष्ट्र में फूलों की घाटी (Trip to Kaas Plateau : Maharashta's Valley of Flower-Hindi Blog)

ऊटी और कुन्नूर : नीलगिरी का स्वर्ग (Trip to Ooty & Coonoor - Hindi Blog)