Тёмный

Send Emails from Excel That Capture Data From Your Worksheet 

Officeinstructor
Подписаться 81 тыс.
Просмотров 35 тыс.
50% 1

There are situations where you want to email clients, suppliers, patients, or students, based upon the data you have in your Excel spreadsheet… and you need to send them Personalized emails, but you don’t want to create any code in VBA
In this tutorial I show you how to send Personalized emails that capture data from your Excel worksheet with very simple steps that do not require using VBA.
As a bonus tip, I show you as well how to attach the entire Workbook to an email and how to send the current worksheet as the body of an email with ONE SINGLE CLICK.
So, let’s dive in

Опубликовано:

 

14 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 52   
@CIChannel77
@CIChannel77 Год назад
oh my...I´ve been looking for this solution for weeks now! I gave up and while looking at random youtube videos it pops up! Thanks! Subscribed!
@Officeinstructor
@Officeinstructor Год назад
Glad I could help!
@RonDavidowicz
@RonDavidowicz Год назад
Nice video & explanations. I use this method to send monthly reports. 2 issues people should be aware of: 1. When Outlook opens the email, it does not include your default signature 2. The output of the hyperlink function is limited to 255 characters. While this sounds like a lot, it can get used up pretty quickly, especially if the email address(s) are long. If you exceed this limit, Excel will show you a #Value error.
@kasinkelly
@kasinkelly 3 месяца назад
Have you found any solution or work around to the 255 character limit?
@user-sh5ym8gt8f
@user-sh5ym8gt8f Год назад
Brilliant video, clearly explains how to do it.
@IvanCortinas_ES
@IvanCortinas_ES Год назад
Exceptional video. Absolutely essential for Outlook tasks in connection with Excel. Thank you Nabil!!!
@Officeinstructor
@Officeinstructor Год назад
Thank you so much
@Lyriks_
@Lyriks_ Год назад
Nabil !! So glad that you are back !
@Officeinstructor
@Officeinstructor Год назад
Thank you
@khaledseghari1189
@khaledseghari1189 Год назад
Excellent video, thank you very much
@Luciano_mp
@Luciano_mp Год назад
Very useful. I liked this! Thank you very much Nabil!
@Officeinstructor
@Officeinstructor Год назад
Glad to hear that!
@rajeshmajumdar4999
@rajeshmajumdar4999 7 месяцев назад
Wonderful !!! Thank you so much!
@michaelt312
@michaelt312 Год назад
Excellent and informative. Thank you, sir.
@Officeinstructor
@Officeinstructor Год назад
Very welcome
@cedjulemckeever
@cedjulemckeever Год назад
Another great video.
@hridyapal
@hridyapal Месяц назад
Super easy! Thank you
@axion8788
@axion8788 Год назад
Another gem.
@Officeinstructor
@Officeinstructor Год назад
Thanks for watching
@elmagodeviena
@elmagodeviena 2 месяца назад
Thank YOU! 💙
@FRANKWHITE1996
@FRANKWHITE1996 Год назад
Great content. Thanks.
@Officeinstructor
@Officeinstructor Год назад
Much appreciated!
@123mailashish
@123mailashish Год назад
Outstanding Nabil Sir@!!
@Officeinstructor
@Officeinstructor Год назад
Thanks for watching
@cmaman1
@cmaman1 Год назад
Thank you
@abdulhamidalhaddadi2255
@abdulhamidalhaddadi2255 Год назад
تسلم ايدك استاذ نبيل
@Officeinstructor
@Officeinstructor Год назад
Thank you so much
@AnalyticalBae00
@AnalyticalBae00 Год назад
Is it possible to send the email that also includes the content of another sheet in the workbook? And, if so, can I set it to send a separate worksheet for each recipient?
@adnan.bashir
@adnan.bashir 10 месяцев назад
This is very informative video.... Please guide how can i send the selected range of cells via using this same piece of code without VBA?
@tonig5601
@tonig5601 Месяц назад
Would this work for a shared document?
@hasanmougharbel8030
@hasanmougharbel8030 Год назад
Hey there, glad to discover your channel. I have a simple enquiry regarding my outlook application. I tried to enter my email and password in aim to open my account on the outlook application installed on my pc. Unfortunately, a message pop up saying "an encrypted connection to your mail sever server is not available." How can i solve this problem given that i have an installation of microsoft office enterprise 2007 and the pc is already placed within a network inside a company. Thanks for assisting me with this.
@excelonlineadvisor
@excelonlineadvisor Год назад
Could be because of Office Network,. Check with your IT guy
@toolAid
@toolAid 9 месяцев назад
Great video! In the video you had to put DOLLARS into the the formal to it would appear like currency. My question is what if you have a date? Is there a function that you can put after the “&” sign that would show a date? Right now I just get numbers?
@TheK0cur
@TheK0cur Год назад
Its posible to send part of sheet in body via email this way. Example cells form A1 to U1 ?
@tharacz0245
@tharacz0245 3 месяца назад
Can u send a Bach of emails with one click instead of clicking each individually?
@eimran1178
@eimran1178 Год назад
Excellent video. Very clear instructed and informative. Upvote. Thank you very much Could you perhaps explain how you add a new line in your body. I want to end the mail with additional sentences and a kind regards, but I would like to have it in a professional way rather than one long sentence.
@classyjazzer
@classyjazzer Год назад
CHAR(10) will add an additional line. So, when you concatenate it, you would add &CHAR(10)& to your body to add a line between the last sentence of the previous line and the first sentence starting a new line. Hope that makes sense and helps. :)
@audreyorkild8771
@audreyorkild8771 7 месяцев назад
How do you add a new line?
@bskrmusic3932
@bskrmusic3932 10 месяцев назад
Sir, Request your support, Sir, how send list of invoices on the body of the email and also as attached with specific condition code wise outstanding automatically flash out to Clients.. please suggest us Sir 🙏
@edwinmassey85
@edwinmassey85 6 месяцев назад
Hi Nabil, How can we share the table in the email
@nairobi203
@nairobi203 Год назад
I have a problem with the lenght of the string you can enter in the Hyperlink formula.... So it does not 100% work for me...
@shafikmiah
@shafikmiah 5 месяцев назад
How can I send only specific columns from my work sheet in an email. For example: I want to create a stock reorder email to the supplier, but I only want to send the item names and the amount of each item I want to order. I don’t want to send other elements I have on the work sheet like amount in stock, minimum stock, stock value etc… Is this possible Thanks in advance.
@mosheslonim3255
@mosheslonim3255 Год назад
Can this be done from Gmail instaed of Outlook?
@Officeinstructor
@Officeinstructor Год назад
It will fire up your default email application
@excelonlineadvisor
@excelonlineadvisor Год назад
Yes
@muhammadwaqar8069
@muhammadwaqar8069 Год назад
Can we add emails via VLOOKUP,
@adnan.bashir
@adnan.bashir 10 месяцев назад
Yes i have done it my self
@user-qn7rg8ky4u
@user-qn7rg8ky4u 7 месяцев назад
Does Not Work with Excel online version because it can't connect to your machines email program preference. Every other mailto: link on the internet works and opens your default mailto: client but not Excel links.
@judithroom3656
@judithroom3656 4 месяца назад
"
@himanshu23457
@himanshu23457 8 месяцев назад
Outlook mail box not opening when I click on mail recipients option I have outlook downloaded in my laptop but outlook mails are not opening when I click on mail recipients. How to solve this problem please help
@bskrmusic3932
@bskrmusic3932 10 месяцев назад
Sir, Request your support, Sir, how send list of invoices on the body of the email and also as attached with specific condition code wise outstanding automatically flash out to Clients.. please suggest us Sir 🙏
Далее
Send Emails from Excel with Power Automate
8:22
Просмотров 288 тыс.
How To Use The Scan Function in Excel
10:14
Просмотров 41 тыс.