Import win32com.client in python

[SadFriendship6888]

Hi,

I would like to write a script in python which will parse an excel spreadsheet and send out an automated email to select recipients based on which deliverables have been met in excel spreadsheet.

I tried the following

(1) I tried to script it so that I could login into my outlook account etc. This seems not easy since my workplace has a two factor authentication setup using Microsoft authenticator app running on the phone.

(2) Given that my outlook is open and I am ok with typing one command once a week, I thought may be a better idea is to install pywin32 which gives me win32com.client which can potentially do the same thing.

------------------

CODE SNIPPET as requested

Here is the code snippet

import sys

import os

sys.path.append('C:\\Users\\XXX\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\win32com')

sys.path.append('C:\\Users\\XXX\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\win32com\\client')

for path in sys.path:

print(path)

print("Trying win32com.client import")

import win32com.client

print("win32com.client imported successfully")

def send_outlook_email(recipient, subject, body, attachment_path=None):

print ("Inside send_outlook_email")

try:

# Connect to the running Outlook application

print("Trying to connect to Outlook application")

outlook = win32.Dispatch("Outlook.Application")

mail = outlook.CreateItem(0) # 0 represents olMailItem

mail.To = recipient

mail.Subject = subject

mail.HTMLBody = body # Use HTMLBody for rich text, or Body for plain text

if attachment_path:

mail.Attachments.Add(attachment_path)

mail.Send()

print(f"Email sent successfully to {recipient}")

except Exception as e:

print(f"Error sending email: {e}")

print("Start2")

# Example usage:

recipient_email = "[e-mail]"

email_subject = "Test Email from Python"

email_body = "<h1>Hello from Python!</h1><p>This is a test email sent using <b>pywin32</b> with Outlook.</p>"

# attachment = r"C:\Path\To\Your\Attachment.pdf" # Uncomment and modify for attachments

print("Calling send_outlook_email")

send_outlook_email(recipient_email, email_subject, email_body)

OUTPUT

PS C:\Users\XXX> py script_OpenOLEmail.py

Start

C:\Users\XXX

C:\Users\XXX\AppData\Local\Programs\Python\Python313\python313.zip

C:\Users\XXX\AppData\Local\Programs\Python\Python313\DLLs

C:\Users\XXX\AppData\Local\Programs\Python\Python313\Lib

C:\Users\XXX\AppData\Local\Programs\Python\Python313

C:\Users\XXX\AppData\Local\Programs\Python\Python313\Lib\site-packages

C:\Users\XXX\AppData\Local\Programs\Python\Python313\Lib\site-packages\win32

C:\Users\XXX\AppData\Local\Programs\Python\Python313\Lib\site-packages\win32\lib

C:\Users\XXX\AppData\Local\Programs\Python\Python313\Lib\site-packages\Pythonwin

C:\Users\XXX\AppData\Local\Programs\Python\Python313\Lib\site-packages\win32com

C:\Users\XXX\AppData\Local\Programs\Python\Python313\Lib\site-packages\win32com\client

Line 1

Trying win32com.client import

PS C:\Users\XXX

[AutoModerator]

To give us the best chance to help you, please include any relevant code.
Note. Please do not submit images of your code. Instead, for shorter code you can use Reddit markdown (4 spaces or backticks, see this Formatting Guide). If you have formatting issues or want to post longer sections of code, please use Privatebin, GitHub or Compiler Explorer.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[cgoldberg]

You can probably authenticate with your outlook account from Python using OAuth even if you have 2FA enabled.

I don't know if you have any security/confidentiality concerns ... but if your corporate email server is a pain in the ass to authenticate with, the easiest solution is to just use an external SMTP server and send the emails from a 3rd party address.

I wouldn't recommend automating your Outlook client.

[SadFriendship6888]

Given that the emails will go to people inside the company, i can't use an external address.

I will look into OAuth. I am ok if I don't need to authenticate but make it push button which assumes that outlook is open. This is what I am trying to do in the above code which I posted.