Send Emails from Excel That Capture Data From Your Worksheet

Рет қаралды 34,257

Күн бұрын

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

Пікірлер: 52

@hridyapal 19 күн бұрын

Super easy! Thank you

@user-sh5ym8gt8f Жыл бұрын

Brilliant video, clearly explains how to do it.

@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 Жыл бұрын

Glad I could help!

@khaledseghari1189 Жыл бұрын

Excellent video, thank you very much

@IvanCortinas_ES Жыл бұрын

Exceptional video. Absolutely essential for Outlook tasks in connection with Excel. Thank you Nabil!!!

@Officeinstructor Жыл бұрын

Thank you so much

@Lyriks_ Жыл бұрын

Nabil !! So glad that you are back !

@Officeinstructor Жыл бұрын

Thank you

@rajeshmajumdar4999 6 ай бұрын

Wonderful !!! Thank you so much!

@cedjulemckeever Жыл бұрын

Another great video.

@Luciano_mp Жыл бұрын

Very useful. I liked this! Thank you very much Nabil!

@Officeinstructor Жыл бұрын

Glad to hear that!

@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 3 ай бұрын

Have you found any solution or work around to the 255 character limit?

@michaelt312 Жыл бұрын

Excellent and informative. Thank you, sir.

@Officeinstructor Жыл бұрын

Very welcome

@axion8788 Жыл бұрын

Another gem.

@Officeinstructor Жыл бұрын

Thanks for watching

@elmagodeviena Ай бұрын

Thank YOU! 💙

@FRANKWHITE1996 Жыл бұрын

Great content. Thanks.

@Officeinstructor Жыл бұрын

Much appreciated!

@123mailashish Жыл бұрын

Outstanding Nabil Sir@!!

@Officeinstructor Жыл бұрын

Thanks for watching

@cmaman1 Жыл бұрын

Thank you

@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?

@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?

@toolAid 8 ай бұрын

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?

@abdulhamidalhaddadi2255 Жыл бұрын

تسلم ايدك استاذ نبيل

@Officeinstructor Жыл бұрын

Thank you so much

@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 Жыл бұрын

Could be because of Office Network,. Check with your IT guy

@TheK0cur Жыл бұрын

Its posible to send part of sheet in body via email this way. Example cells form A1 to U1 ?

@tonig5601 21 күн бұрын

Would this work for a shared document?

@tharacz0245 3 ай бұрын

Can u send a Bach of emails with one click instead of clicking each individually?

@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.

@bskrmusic3932 9 ай бұрын

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 🙏

@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 Жыл бұрын

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. :)

@edwinmassey85 5 ай бұрын

Hi Nabil, How can we share the table in the email

@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...

@mosheslonim3255 Жыл бұрын

Can this be done from Gmail instaed of Outlook?

@Officeinstructor Жыл бұрын

It will fire up your default email application

@excelonlineadvisor Жыл бұрын

Yes

@audreyorkild8771 6 ай бұрын

How do you add a new line?

@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.

@muhammadwaqar8069 Жыл бұрын

Can we add emails via VLOOKUP,

@adnan.bashir 9 ай бұрын

Yes i have done it my self

@judithroom3656 4 ай бұрын

@himanshu23457 7 ай бұрын

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 9 ай бұрын