Python O365 发送邮件

Question

我正在尝试使用电子邮件 rolodex 的数据框将附件和求职信迭代到数据框中找到的索引数量。谁能告诉我如何通过下面的 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()

email_list 是一个 3 列，编号，姓名，email_address

Answer 1

让我们使用itertuples:

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

使用:

    m.setRecipients(i.email_address)

或

    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()