debug-批量email-带附件

import pandas as pd
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

#处理数据
data=pd.read_excel('D:\\客户资料统计表.xlsx',sheet_name=0)
e_mail=data['联系人邮箱'].tolist()
print(e_mail)

#将邮箱转换为逗号分割的字符串
to=','.join(e_mail)
print(to)

user=''
code=''

#定义该邮件由多个部分组成
message=MIMEMultipart()
message.attach(MIMEText(mail_message,'html','utf-8'))
attachment1=MIMEText(open('D:\\pip.txt','rb').read(),'base64','utf-8')
attachment1['Content-Type']='application/octet-stream'
attachment1['Content-Disposition']='attachment;filename="pip.txt"'
message.attach(attachment1)

message['Subject']='AnotherTest'
message['From']=user
message['to']=to

server=smtplib.SMTP_SSL('smtp.163.com',465)
server.login(user,code)
server.send_message(message)
server.quit()
print('email sent')

C:\Users\Administrator\PycharmProjects\pythonProject2\venv\Scripts\python.exe C:\Users\Administrator\PycharmProjects\pythonProject2\test.py 
Traceback (most recent call last):
  File "C:\Users\Administrator\PycharmProjects\pythonProject2\venv\Lib\site-packages\pandas\compat\_optional.py", line 135, in import_optional_dependency
    module = importlib.import_module(name)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python312\Lib\importlib\__init__.py", line 90, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap>", line 1387, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1360, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1324, in _find_and_load_unlocked
ModuleNotFoundError: No module named 'openpyxl'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\Administrator\PycharmProjects\pythonProject2\test.py", line 7, in <module>
    data=pd.read_excel('D:\\客户资料统计表.xlsx',sheet_name=0)
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Administrator\PycharmProjects\pythonProject2\venv\Lib\site-packages\pandas\io\excel\_base.py", line 495, in read_excel
    io = ExcelFile(
         ^^^^^^^^^^
  File "C:\Users\Administrator\PycharmProjects\pythonProject2\venv\Lib\site-packages\pandas\io\excel\_base.py", line 1567, in __init__
    self._reader = self._engines[engine](
                   ^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Administrator\PycharmProjects\pythonProject2\venv\Lib\site-packages\pandas\io\excel\_openpyxl.py", line 552, in __init__
    import_optional_dependency("openpyxl")
  File "C:\Users\Administrator\PycharmProjects\pythonProject2\venv\Lib\site-packages\pandas\compat\_optional.py", line 138, in import_optional_dependency
    raise ImportError(msg)
ImportError: Missing optional dependency 'openpyxl'.  Use pip or conda to install openpyxl.

Process finished with exit code 1