You can ask your IT staff for the exchanger server. You can also try and find it in the outlook. This article list the steps on how to get your exchange server’s address: www.nucleustechnologies.com/blog/how-to-find-exchange-server-address/amp/
Hi Almas, if you want to use conditional formatting then I'd suggest use a regular dataframe. Apply your conditional formatting and then call the to_html() function on to convert it to text. You should be able to send it in the email body.
Hi Swapnil, thanks for stopping by. Here's how you would send an html file as an attachment. html = open("data.html") msg = MIMEText(html.read(), 'html') msg['From'] = from msg['To'] = to msg['Subject'] = "Weekly Sales Report" # message = msg.as_string()
Broken images can be due to incorrect path so check the image path and try again. Certain email client do not load images i.e. you need to download the images in outlook.
Hi David, you can pass in multiple recipients as a list when you send an email. # declare receiver emails variable receiver = ['emailone0@gmail.com', 'email2@gmail.com']
output = pretty_html_table(data,"blue_light") 'module' object is not callable . . message.attach(MIMEText(body_content,'html')) 'DataFrame' object has no attribute 'encode'
it went great up to section4 - then you lost me, some more basic example with more context on the different methods used would have been more effective for me. Too bad.
Mate, this was really good. Keep up the good work.
Very nice explanation and worked for me. Thanks for uploading.
It was a great explanation. Looking forward for more such content.
Excellent job! Thank you for posting!
i can't thank you enough!!!! liked!
Clean clear
Thank you brother
fantastic
I want to send mail from my office outlook. What will be the server? Please help. All email address will be official domain.
You can ask your IT staff for the exchanger server. You can also try and find it in the outlook. This article list the steps on how to get your exchange server’s address:
www.nucleustechnologies.com/blog/how-to-find-exchange-server-address/amp/
@@BiInsightsInc thanks
@@BiInsightsInc sir what is your LinkedIn profile name
Hi @@hellofrombd1960 you can find me on LinkedIn here: www.linkedin.com/in/haq-nawaz/
How can we conditional format the table cells? The argument provided by pretty_html_table doesn't seem to work
Hi Almas, if you want to use conditional formatting then I'd suggest use a regular dataframe. Apply your conditional formatting and then call the to_html() function on to convert it to text. You should be able to send it in the email body.
Thanks
Can you please show how to attach an HTML file for example with name data.html as an attachment in email?
Hi Swapnil, thanks for stopping by. Here's how you would send an html file as an attachment.
html = open("data.html")
msg = MIMEText(html.read(), 'html')
msg['From'] = from
msg['To'] = to
msg['Subject'] = "Weekly Sales Report"
#
message = msg.as_string()
how to do you deal with broken images after send your html style ?!!
Broken images can be due to incorrect path so check the image path and try again. Certain email client do not load images i.e. you need to download the images in outlook.
Hi , how to send mails to multi recipients with html ?
Hi David, you can pass in multiple recipients as a list when you send an email.
# declare receiver emails variable
receiver = ['emailone0@gmail.com', 'email2@gmail.com']
output = pretty_html_table(data,"blue_light")
'module' object is not callable
.
.
message.attach(MIMEText(body_content,'html'))
'DataFrame' object has no attribute 'encode'
Hi Abhishek, you need to make sure you've "pretty-html-table" installed and you're importing in your script before calling it.
it went great up to section4 - then you lost me, some more basic example with more context on the different methods used would have been more effective for me. Too bad.
Noted!