如何使用python电子邮件widg从sqlite3查询发送多行电子邮件

Question

我用python和tkinter GUI制作了一个应用程序。 在这个应用程序中，我有一个按钮，当我单击它时，我想使用python的标准电子邮件库将数据库中的某些记录通过电子邮件发送给客户。然而，我似乎只能发送一张唱片

我是不是忽略了什么

def Send_OC_Worksheet_Mail(self, event):
    fromaddr = "my email address"
    toaddr = "customer email address"
    msg = MIMEMultipart()
    msg['From'] = fromaddr
    msg['To'] = toaddr
    msg['Subject'] = "my subject"
    Send_Jobs_List_Qry = (c.execute('SELECT Job_Description, Job_Date FROM Jobs WHERE Worksheet_Mailed=?', (0,  ))).fetchall()
    for Send_Jobs_List_Row in Send_Jobs_List_Qry:
        Job_Descr = str(Send_Jobs_List_Row[0])
        Job_Date = str(Send_Jobs_List_Row[1])
        Job_Body = (Job_Date+':'+Job_Descr+'\n')
        body = Job_Body
        msg.attach(MIMEText(body, 'html'))

    server = smtplib.SMTP('smtp.gmail.com', 587)
    server.starttls()
    server.login(fromaddr, "password")
    text = msg.as_string()
    server.sendmail(fromaddr, toaddr, text)
    server.quit()