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.
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?
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.
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.
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 🙏
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?
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.
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. :)
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.
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
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 🙏
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!
Glad I could help!
Nabil !! So glad that you are back !
Thank you
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.
Have you found any solution or work around to the 255 character limit?
Exceptional video. Absolutely essential for Outlook tasks in connection with Excel. Thank you Nabil!!!
Thank you so much
Brilliant video, clearly explains how to do it.
This is GREAT! Thanks a lot.
Wonderful !!! Thank you so much!
Super easy! Thank you
Very useful. I liked this! Thank you very much Nabil!
Glad to hear that!
Excellent and informative. Thank you, sir.
Very welcome
Excellent video, thank you very much
Another gem.
Thanks for watching
Outstanding Nabil Sir@!!
Thanks for watching
Another great video.
Thank YOU! 💙
Great content. Thanks.
Much appreciated!
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?
Would this work for a shared document?
Hi I am having trouble with this when the message body or email seems to be too long, have you ever experienced this? Thanks
Thank you
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?
Can u send a Bach of emails with one click instead of clicking each individually?
Hi Nabil,
How can we share the table in the email
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.
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.
Could be because of Office Network,. Check with your IT guy
تسلم ايدك استاذ نبيل
Thank you so much
Its posible to send part of sheet in body via email this way. Example cells form A1 to U1 ?
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 🙏
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?
How do you add a new line?
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.
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. :)
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.
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...
Can this be done from Gmail instaed of Outlook?
It will fire up your default email application
Yes
Can we add emails via VLOOKUP,
Yes i have done it my self
"
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
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 🙏