How to automatically send customized mails with attachments from Gmail

In this tutorial we would be learning:
1. How to automatically send emails with attachments from Gmail using Google spreadsheets
Pre-requisite: • How to automatically s...

[@rameshbhateshra2320]

Hi, made a code to submit the invoices to my client in individual mail, all thanks to you. Till today, I was doing that work manually, but now I can save my 4-5 hours every week. Thank you so much for this informative video. 😊😊

[@AutomationMadeEasy]

Fantastic!

[@hermonburger7143]

This videos has helped me alot. Is there a way to attach multiple attachments to a single mail on this system as I need to send a personalized email with 17 of the same attachments to multiple people

[@Asad-gg4ug]

Excellently explained.Thankyou!!

[@AutomationMadeEasy]

Glad it was helpful!

[@koungsareth8623]

Please do more appscript from beginner to advance.thanks

[@Rhino3D.Education]

Very very nice, thanks.

[@AutomationMadeEasy]

Thank you too!

[@remiteksolutions6328]

Hi, Mine giving an error "folder.next is not a function"

[@mikilau814]

hellooo~ why does mine said reference error: file is not defined sendMails (I've turned on the API thing) thankyouuu

[@AutomationMadeEasy]

seems there is some issue with the variable name file in your script

[@CraftingGems]

Great work and explanation 👍👌 👏

[@AutomationMadeEasy]

Glad you liked it

[@gairikmukherjee2321]

I am getting an error saying that iterator has reached the end and can not get next object in the Mail.App line. I have copied it exact same. Can someone help?

[@drdiehard4]

Just make sure have bracket ( )...esp at line getValue or getDisplayValue etc

[@sayhaanahmed4244]

Hi I am facing this error - exception cannot retrieve the next object iterator has reached the end - it's showing that the error is in the mail send line . Please tell me the solution

[@sayhaanahmed4244]

Facing in mailapp. Send mail

[@ragasamarionarrheniusc.3301]

@@sayhaanahmed4244 I have the same problem

[@DeleshGrg]

Can you share the screenshot

[@cutbox7153]

Interesting! Can u make a video on taking the document as a template and sheet data as a source to trigger an automate email?

[@AutomationMadeEasy]

refer below tutorial: kzbin.info/www/bejne/m5myeISofN2Vjbs

[@SixBlueBoats]

Do you take custom orders to implement similar services for a small enterprise?

[@AutomationMadeEasy]

write into [e-mail]

[@Usuaurio-kj1ym]

Hello, thanks it works for me

[@AutomationMadeEasy]

Glad to hear that

[@tambolisadik]

can you share this app scipt with sheet

[@shubhamsharma8373]

can you please make a video on where we can make an invoice and send that invoice as a pdf to the customer by clicking on the button please must reply it will be grateful to you

[@ahmadaminuddin6591]

Hi, may I know how to send bold words in email?

[@rajeshsukheja4802]

Hey.. thanks for ur valuable information could u suggest how can we transfer data frm excel to any software (auyomation)

[@AutomationMadeEasy]

can you explain in detail with an example what exactly you are looking for. Automation is possible but need to know the requirement for suggesting as apt solution.

[@rajeshsukheja4802]

@@AutomationMadeEasy thanks for quick reply.... so I have software called "video pal" (kind of pop-up sign up but in video avtar) where i want to offer those service by auto filling data frm excel and some bot will capture the excel data and put into my video pal software

[@AutomationMadeEasy]

if it is a web page you can try below tutorial: kzbin.info/www/bejne/Y3i4qGVomsiFras

[@laisonkc]

Is it possible to add custom subject and mutiple files

[@AutomationMadeEasy]

yes, with some changes and how data is structured it is very much possible

[@MaheshHasarmani]

Can I get the sheet for reference?

[@sridharsri23]

How to send a Google sheet like this

[@von2648]

thank you, but what if the files located in a different folder for different people?

[@AutomationMadeEasy]

as long as file path is correct, this approach will work

[@sojuelpsicologia3934]

Hi I am also facing this error: "exception cannot retrieve the next object iterator has reached the end" its in the MailApp.sendEmail part, help!!!!

[@AutomationMadeEasy]

Error suggests you are referring to a blank row. May be there some issue with your loop.

[@immi1498]

Add Google docs for data in format

[@InsideMyWall]

If I want to send invoice only to selected people from my list in spreadsheet, how to do that??

[@AutomationMadeEasy]

coming soon

[@saurav_sovi]

Brother can you share link of this google sheet

[@tejved1477]

Where's the code? someone pls send the link

[@Saywhatohno]

the file.next ..... this part is giving me an error: Exception: Cannot retrieve the next object: iterator has reached the end.

[@AutomationMadeEasy]

this means there are no more files in the folder. Check if the id of the folder is correct.

[@Saywhatohno]

@@AutomationMadeEasy ID is correct but my folder is nested in a folder and yes I also used folder ID instead of folder name because there can be duplicated names. I will check again and update here, let me know if you think something else is off? I will post my script here .

[@kushgada2133]

What is the syntax for attaching multiple pdf files ? Please help need it urgently

[@AutomationMadeEasy]

syntax will remain the same. you will have to only provide accurate file locations.

[@kushgada2133]

@@AutomationMadeEasy I have to send 5 pdf through automation how will it happen can you please give a syntax example with file location an example will help me coz I can't figure it out since morning

[@kushgada2133]

Our if you make a video for multiple file attachments that will also work 😅

[@kushgada2133]

Brother please help me out its very urgent

[@AutomationMadeEasy]

for customized urgent requests write into [e-mail]

[@muddadavamsikrishna6314]

Hi Can u make a tutorial for "How to Automate Web Scraping Using apps script"

[@AutomationMadeEasy]

refer below tutorials: kzbin.info/www/bejne/n3rLdqyojsukmKM kzbin.info/www/bejne/qnXJoJWOdq-Ld80

[@DeleshGrg]

Will it charge for Google cloud platform

[@AutomationMadeEasy]

if you want advanced services you will have to pay for G-Suite License. For normal use as demonstrated in the tutorial there are no charges associated.

[@DeleshGrg]

How to add someone in cc

[@yashchaudhari1104]

@@DeleshGrg Have you got your answer If yes please share

[@yashchaudhari1104]

@@AutomationMadeEasy how to add someone in cc

[@yashchaudhari1104]

@@AutomationMadeEasy how to add 2files for same persoan

[@anwar9784]

Bro can you make video for office 365 forms.

[@anwar9784]

Automation to fill on office forms with excel vba.

[@yasirahmedkhan4405]

Wonderful 💋

[@AutomationMadeEasy]

Thanks 🤗

[@shwanabraimhassan8706]

well done, can i have the script please

[@AutomationMadeEasy]

most of the scripts are available on the blog automationandagile under Google Sheets

[@arcos9344]

It's giving me this nightmare "Exception: Argument cannot be null: contentType" someone please help!!

[@AutomationMadeEasy]

need to see your code to understand the error cause

[@arcos9344]

@@AutomationMadeEasy function sendMails() { var wrkBk = SpreadsheetApp.getActiveSpreadsheet(); var wrkShtEmailIDs = wrkBk.getSheetByName("EMail_ID"); var wrkShtMessage = wrkBk.getSheetByName("Mail_Details"); const subject = wrkShtMessage.getRange('A2').getValues(); const message = wrkShtMessage.getRange('B2').getValues(); var folder = DriveApp.getFoldersByName('ADIEU23PASS').next(); for (var i=2;i

[@AutomationMadeEasy]

try using getDisplayValue() where you have used getValues() to read data from spreadsheet

[@arcos9344]

@@AutomationMadeEasy will do

[@shaitaan0666]

send me code

[@AutomationMadeEasy]

plz refer blog automationandagile

[@gairikmukherjee2321]

When I used MimeType.XLSX it shows argument is null, can someone please help ??