Python O365发送Emai

Question

我试图使用电子邮件rolodex的dataframe来迭代附件和封面信，使之达到dataframe中找到的索引数量。有谁能告诉我，我是如何通过下面的i为每个设置引用特定的列吗？ 谢谢

body_of_email = "This is a call to arms" 
for i in email_list:
    #Send to Recipients individually from list
    m.setRecipients(i.columns[2])
    #Attachments
    m.attachments.append(excel_att)
    m.attachments.append(cover_letter)
    m.setSubject(i.columns[1] + ' I made an email script.')
    m.setBody(body_of_email)
    m.sendMessage()

电子邮件列表是一个3列，编号，姓名，电子邮件地址

Answer 1

{cd1>使用^：

for i in email_list.itertuples():
    #Send to Recipients individually from list

使用：

^{pr2}$

或者

    m.setRecipients(i[2])
    #Attachments
    m.attachments.append(excel_att)
    m.attachments.append(cover_letter)
    m.setSubject(i.name + ' I made an email script.')

或者

    m.setSubject(i[1] + ' I made an email script.')
    m.setBody(body_of_email)
    m.sendMessage()