Send email to multiple recipients using win32com module in Python

Question

I am using win32com to send emails after my code is done. However, I cannot figure out how to send it to more than 1 person. Now I can only add myself in cc, but not in the recipient list.

Here is my code:

import win32com.client
import datetime as date

olMailItem = 0x0
obj = win32com.client.Dispatch("Outlook.Application")
newMail = obj.CreateItem(olMailItem)
newMail.Subject = 'Hi'
newMail.Body = 'Hi'
newMail.To = 'Amy'
newMail.CC = 'Bob'    
newMail.Send()

However if I try this:

newMail.To = ['Amy','Bob']

An error occurs:

pywintypes.com_error: (-2147352567, 'Exception occurred.', (4096, u'Microsoft Office Outlook', u'Type Mismatch: Cannot coerce parameter value. Outlook cannot translate your string.', None, 0, -2147352571), 1)

Can anyone help?

Oliver · Accepted Answer · 2014-03-28 06:05:38Z

34

Try separating by semicolons:

newMail.To = 'Amy; john; sandy'

If you do a web search for "outlook interop createitem" you can find the docs for MailItem.To where this is explained.

Update: this is not an Outlook script, it is a Python script that uses Python's win32com module to control Outlook. The docs I'm referring to are the VB/C# docs for Outlook's COM interface (for example the possible values of OlItemType).

edited Mar 28, 2014 at 6:05

answered Mar 28, 2014 at 0:03

Oliver

30k12 gold badges81 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

lsheng Over a year ago

Thanks I actually dont know whats going on inside this module, and I havent written outlook scripts before. Is MailItem.To a built in function in Outlook? If so, I think for most problems I can just go for Outlook Docs.

Oliver Over a year ago

@Twinkle If this worked please accept answer so we know this resolved issue. I will clarify answer.

Naufal Over a year ago

If you want it it be more dynamic then you should try the following: newMail.To = ";".join([i for i in to if isinstance(to, list) == True]).

Anuj Masand Over a year ago

How to add a specific sender name if required?

Clarence Hairston · Accepted Answer · 2022-01-11 20:59:22Z

0

Convert the list to a string, make sure you add the ';' at the end of each recipient:

newMail.To = "".join(<your_list>)

answered Jan 11, 2022 at 20:59

Clarence Hairston

11 bronze badge

1 Comment

PyHP3D Over a year ago

Shouldn't this be newMail.To = ";".join(<your_list>) (including the semicolon in the join statement)

Collectives™ on Stack Overflow

Send email to multiple recipients using win32com module in Python

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related