Send Email directly from Excel and Google Sheets using a Formula

[@annochkaLondon]

This is the only video in the whole KZbin which really shows HOW TO SEND EMAIL USING HYPERLINK IN GOOGLE SHEETS!!! All the other videos are AppScrits... Thank you so much!!!

[@ericae6611]

You have saved me many gray hairs by showing me how to do this. Thank you!

[@brunoferreira7197]

Hello, thanks for this tutorial, in my case "email link" option is not working! "email-link" is not a link, is a normal text...

[@vishwamithran8853]

thank u ...but it directly open open in ms mail how to changes as chrome

[@eessaabdul6435]

Very useful and thank you........please i kindly need some data for practice

[@umeshdube1861]

How can we send in google sheet while using hyperlink formula

[@NigelMayhew1]

Thank you!

[@ewilner]

Do you have a sheet I can download?

[@pushpenderdixit7999]

Getting error while sending the email tha could not perform this operation because the default mail client is not properly installed.

[@shubhadipbanerjee6386]

Very useful video, You can please share how I can attach any PDF or JPG file using this.

[@gervil100]

very helpful. But how do I attach a pdf file to each email? Even better, how do I add a specific page of a pdf file to each email address?

[@teddyw.charawa8989]

You are awesome!!

[@IsabelleRo]

Hello, thank you for this very valuable video, I have a question: What if I prepare a google sheet to send email directly but I would like to be sent via different email box I have. Is there a way to do this? Let's say that I want to send an email from my accounting email box for line 2 and I want to send the email from my support email box for line 3. Is there a formula or google drive/google sheet application that give you the capacity to do that? Thanks.

[@bockjrnl]

Great video! Is there a way to add a larger amount of body tekst? The limit is quite small.

[@bluefeathertraining]

Tried this but when i click the link just a blank tab get opened on chrome. What did I miss?

[@HumNahiSudhrege]

Can you please create option chain of NSE India

[@user-tr8vs4cq7f]

This worked for me only on excel. What would the formula be for google sheets? I tried it on google sheets and the formula does not work its different. Can you provide the formula that you would input in the google sheets cell. Thanks.

[@BobbyHarris]

Do you know if there there is a way to force using MS Outlook to send the email instead of your Gmail account?

[@TheTonymillet]

Thank you, this helps a lot. Question, I am trying to use an existing date from the sheet, but it does not translate as a date but a string of numbers. Any way to fix that?

[@TEKNISHA]

You can use text function to make sure that the output is in date format

[@sojidaniel5703]

If the date is in B2 then the text function to return the date in the desired format will be =TEXT(B2, "DD-MMMM-YYYY") OR =TEXT(B2, "DD/MM/-YYYY")

[@shivaprrasadsk3060]

Can we automate email with one click to send bulk? Secondly Google sheets allow to send multiple emails from same IP address?

[@md.adibibneyousuf5007]

I followed what you did. But in my Email link cell it is showing Value! What I have done I inserted some text instead of the number in your 'Amount Due' column. Pls suggest.

[@karthikchandran]

how to attach a file using spreadsheet for emailing..?

[@shubhadipbanerjee6386]

Can i attach a PDF file in the mail using an Excel sheet

[@SaketSaurav-pt3wg]

my cc is not working, any guesses?

[@syedmahbub1246]

Something problem, This Formula are not work. Send email click are blank page. Directly not email option Please help

[@sachinnepili3066]

I have applied the formula and even my chrome also opened, even my gmail is alos logged in but mail is not drafting, Help me to get out of it