Warm tip: This article is reproduced from serverfault.com, please click
email outlook python smtp win32com

How to get sender SMTP email address from MailItem in outlook using python?

发布于 2020-12-02 13:25:48

I am trying to get the sender email address of MailItem using Python and win32, but whenever Exchange address is found, I am unable to get the SMTP address. I tried everything available on the net, but it is returning an empty string. Here is the code snippet I'm using:

if msg.Class == 43:
    if msg.SenderEmailType == 'EX':
      print(msg.Sender.GetExchangeUser().PrimarySmtpAddress)
    else:
      print(msg.SenderEmailAddress)
Questioner
Pranayan Metiya
Viewed
0
分享
Dmitry Streblechenko 2020-12-02 23:43:19

You can try to read PidTagSenderSmtpAddress MAPI property (DASL name http://schemas.microsoft.com/mapi/proptag/0x5D01001F) using MailItem.PropertyAccessor.GetProperty - take a look at the message with OutlookSpy (click IMessage button) or MFCMAPI.

Pranayan Metiya 2020-12-03 20:38:32

Using OutlookSpy I have been able to find the property I need, which is PidTagSenderSmtpAddress_W (yeah, very close to what you mentioned). However the object and the property are incompatible. Hence I need to add something so that the property is compatible. Please help me with the last step.

Dmitry Streblechenko 2020-12-03 20:40:21

GetProperty() returns generic object', Cast it to string.

Pranayan Metiya 2020-12-04 18:14:33

I suppose instead of MailItem I should specify the item itself, i.e., msg in my case?

Dmitry Streblechenko 2020-12-04 18:20:51

Yes. MailItem is the COM object class name - docs.microsoft.com/en-us/office/vba/api/outlook.mailitem

Pranayan Metiya 2020-12-04 18:22:27

Presently I am doing msg.PropertyAccessor.GetProperty.PidTagSenderSmtpAddress_W, and the error shown is AttributeError: 'function' object has no attribute 'PidTagSenderSmtpAddress_W'. And looking at the error, I am not very confident that casting the object to string will be helpful.

热门帖子

1
求推荐硬路由（1000 内）
2
学英语的朋友们可以来看看 https://langplayground.top/
3
华中科大的计算机技术的在职硕士，职场认可度如何？
4
十兆宽带 100 块钱一个月我是活在 80 年代吗？
5
关于高质量 屏幕共享的问题
6
我是真的受不了打小报告的三八了！
7
怎么管理自己的文件体系
8
[开发者自荐] AirBattery: 在 Mac 端获取所有设备的电量并显示在 Dock 或状态栏上
9
南京移动 IPV6 被停
10
WireGuard 跨国组网失败后,一个新工具的诞生

热门github

1
Implementation of paper - YOLOv9: Learning What You Want to Learn Using Programmable Gradient Information
2
A Windows and Office activator using HWID / Ohook / KMS38 / Online KMS activation methods, with a focus on open-source code and fewer antivirus detections.
3
Get up and running with Llama 2, Mistral, Gemma, and other large language models.
4
该项目可以让你通过订阅的方式使用Cloudflare WARP+，自动获取流量。This project enables you to use Cloudflare WARP+ through subscription, automatically acquiring traffic.
5
Multi functional app to find duplicates, empty folders, similar images etc.
6
Xray panel supporting multi-protocol multi-user expire day & traffic & ip limit (Vmess & Vless & Trojan & ShadowSocks & Wireguard)
7
The Free Software Media System
8
lightweight, standalone C++ inference engine for Google's Gemma models.
9
📚 Freely available programming books
10
A collective list of free APIs
11
1️⃣🐝🏎️ The One Billion Row Challenge -- A fun exploration of how quickly 1B rows from a text file can be aggregated with Java
12
🎓 Path to a free self-taught education in Computer Science!
13
Curso para aprender el lenguaje de programación Python desde cero y para principiantes. 75 clases, 37 horas en vídeo, código, proyectos y grupo de chat. Fundamentos, frontend, backend, testing, IA...
14
This repository contains System Design resources which are useful while preparing for interviews and learning Distributed Systems
15
Mamba is a new state space model architecture showing promising performance on information-dense data such as language modeling, where previous subquadratic models fall short of Transformers. It is based on the line of progress on structured state space models, with an efficient hardware-aware design and implementation in the spirit of FlashAttention.