Send Email Using Excel (No VBA Required) - All in One Video

Send Emails through Excel Files using "Hyperlink" Function.
Topic Discussed :-
1. How to add recipient (Use Semicolon (;) for multiple recipients)
2. How to add Subject
3. How to add cc (Use Semicolon (;) for multiple recipients)
4. How to add Bcc (Use Semicolon (;) for multiple recipients)
5. How to add Mail Body ( %0A - Use to give a line between two sentences)
Also, I have shared 1 small dashboard which can be used by HR to send email to new joinee (Welcome Email) or to shared the Resignation Form their employees.
Formula used in E2 cell - HYPERLINK("mailto:"&$B2&"?subject="&(IF(D2="Resignation","Resignation Form","Welcome to XYZ Pvt LTD"))&"&body="&IF(D2="Resignation",Templates!$A$3,Templates!$A$7),"Send Email")
Note : You can edit it according to your requirement.
Limitations :-
There is a character limitation of 256. Therefore you cannot send a large mail body or a paragraph to the recipient. However, you can use VBA for that.
Do Comment, Like & share if you learn something new today.
Telegram :- t.me/+UAVHfg7O...
Instagram :- / exceladvisorr
Emal :- [e-mail]
Sheet Download Link - docs.google.co...

[@siscokid2870]

Great video. How do you add the hyperlinked youtube video in the email body?

[@excelonlineadvisor]

Pls add the UA-cam video url under the body section aa shown in the video

[@excelonlineadvisor]

Check this - ua-cam.com/video/dL68GMOq5U4/v-deo.html

[@stevenkoh9312]

Sequential and good flow best of all similar video. except not break line.

[@rozetagoxhaj9332]

how it works when you want to send the same email for example to 400 people?

[@excelonlineadvisor]

Keep all the email address in 1 cell and use semicolon in between all email address. Rest procedure is same.
OR
USE VBA ua-cam.com/video/brairirL_ZA/v-deo.html