Python O365 发送邮件

我正在尝试使用电子邮件 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

请您参考如下方法:

让我们使用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()