Copy and format excel table to outlook body using python

Question

I am trying to send an outlook email with content from a excel file pasted in the message body of outlook email. I have to use smtplib only

I used the code from here shown below

import csv
from tabulate import tabulate
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
import smtplib
me = '[email protected]'
server = 'internal-server:25'
you = '[email protected]'
text = """
Hello, Friend.

Here is your data:

{table}

Regards,

Me"""

html = """
<html><body><p>Hello, Friend.</p>
<p>Here is your data:</p>
{table}
<p>Regards,</p>
<p>Me</p>
</body></html>
""" 
with open('input.csv') as input_file:
    reader = csv.reader(input_file)
    data = list(reader)
text = text.format(table=tabulate(data, headers="firstrow", tablefmt="grid"))
html = html.format(table=tabulate(data, headers="firstrow", tablefmt="html"))
message = MIMEMultipart(
    "alternative", None, [MIMEText(text), MIMEText(html,'html')])
message['Subject'] = "Your data"
message['From'] = me
message['To'] = you
server = smtplib.SMTP(server)
server.ehlo()
server.sendmail(me, you, message.as_string())
server.quit()

However, it prints the table as below (without table grid lines and format)

I expect my output to be like as shown below (as a table and not as a image in outlook body)

Robᵩ · Accepted Answer · 2022-03-31 01:43:11Z

2

You might want to add a border=1 attribute to your table HTML element. Sadly, tabulate doesn't support such a thing. One way to add the border attribute is to skip tabulate.tabulate and write your own table formatter like so:

def html_tabulate(table):
    table_it = iter(table)
    result = []
    result.append("<table border=1>")
    result.append("<thead>")
    headers = next(table_it)
    result.append("<tr><th>" + "</th><th>".join(headers) + "</th></tr>")
    result.append("</thead>")
    for row in table_it:
        result.append("<tr><td>" + "</td><td>".join(row) + "</td></tr>")
    result.append("</table>")
    return "\n".join(result)

and then use your new function when you create the HTML for your emaill:

html = html.format(table=html_tabulate(data))

answered Mar 31, 2022 at 1:43

Robᵩ

170k20 gold badges251 silver badges323 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

The Great Over a year ago

Hi, I am encountering another related problem in smtplib text message. would you be interested to help? stackoverflow.com/questions/71709672/…

Collectives™ on Stack Overflow

Copy and format excel table to outlook body using python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related