MS Outlook VBA: Get the reply date and time.

Status
Not open for further replies.

Hudas

Member
Outlook version
Email Account
Exchange Server
Hi -

I have a database that records all incoming emails. Now, I want to determine what date and time an email was replied and put in the database so that I can have the duration for time the email was received and replied.

Can anyone please give me an idea?or point me to the right direction. I is greatly appreciated.

Thank you
Hudas
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

Hudas

Member
Outlook version
Email Account
Exchange Server
Thank you Diane! I will try what you suggested!!
 

Hudas

Member
Outlook version
Email Account
Exchange Server
Hi Diane...

In the ms access database i have the message id as the unique identifier of the email received. And when the user reply to the email, and sends the reply.. im trying to catch and match the message id of the email being sent (thinking that the message id is still the same) to what is in the database so that i can determine which email is being replied to and get the time but its giving me null.. How do i determine which email is being replied to when the user clicks the send button?

Can you please give me an idea... I'm pretty new to vba in ms outlook...

Any suggestion is greatly appreciated.

Thank you
Hudas
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

Hudas

Member
Outlook version
Email Account
Exchange Server
Hello Diane,

I understand now that the reply will have a new message ID. I'm lost.. really lost.. How do I get the those numbers that you posted from outlook?

Thank you
Hudas
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I'll see what I can find out - it's not something I've done before and am about as lost as you are. :)
 

Hudas

Member
Outlook version
Email Account
Exchange Server
Thank you Diane for taking the time...I Appreciate it really!
 

Saurdo

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Did anything ever come of this? I'm currently trying to figure out the same thing and stumbled across this thread. This is the closest thing to an answer I've found so far!
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The IDs shown above are available in the message header. You can use the PropertyAccessor to read the PR_TRANSPORT_MESSAGE_HEADERS_W property.

That header, however, is added to a message after it was sent. It's not available when you click the Send button.

I think the most reliable solution acts already when you click the Reply button. Then you know the message you reply to.

Identifying a message isn't easy. Either you use the EntryID, which is unique but gets changed when you move the message, or you use the SearchKey, which never changes but cannot be unique (if you copy the message, the SearchKey will be copied, too).
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M VBA Auto-Reply code for Two Mailboxes on one Outlook Session. Outlook VBA and Custom Forms 4
P Automatic reply on incoming messages in outlook using VBA(only Specifi person) Using Outlook 14
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 0
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
S vba outlook search string with special characters Outlook VBA and Custom Forms 1
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
F Excel VBA to move mails for outlook 365 on secondary mail account Outlook VBA and Custom Forms 1
K Outlook Office 365 VBA download attachment Outlook VBA and Custom Forms 2
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
S Excel vba code to manage outlook web app Using Outlook 10
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
S Problem Checking the available stores in my Inbox (Outlook VBA) Outlook VBA and Custom Forms 0
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
O VBA Outlook Message Attachment - Array Index Out of Bounds Outlook VBA and Custom Forms 0
J Want to learn VBA Macros for Outlook. What book can you recommend? Outlook VBA and Custom Forms 2
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
N How can I increase/faster outlook VBA Macro Speed ? Using Outlook 2
N Outlook Email Rule execution through shortcut keys (VBA codes) Using Outlook 1
A VBA Code in Outlook disappears after first use Outlook VBA and Custom Forms 1
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
G Outlook VBA and Google Calendar ("Events") Outlook VBA and Custom Forms 1
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
B Advanced Search in MS Outlook by VBA and SQL Outlook VBA and Custom Forms 2
K Outlook Archive to PST Files by Date Range VBA Script? Outlook VBA and Custom Forms 1
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
S Find a cell value in excel using outlook vba Using Outlook 1
J Execute Add-In Button from VBA Outlook 2016 Outlook VBA and Custom Forms 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
M Slow VBA macro in Outlook Outlook VBA and Custom Forms 5
T Outlook AntiSpam with VBA Outlook VBA and Custom Forms 1
F "Move to" O365 feature to Outlook client via VBA Outlook VBA and Custom Forms 4
B query outlook using vba Outlook VBA and Custom Forms 13
J VBA to switch Outlook online/offline Outlook VBA and Custom Forms 4
M VBA to change flag status in outlook contact item Outlook VBA and Custom Forms 3
T VBA outlook, detect priority emails Outlook VBA and Custom Forms 5
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
stephen li VBA Outlook send mail automatically by specified outlook mail box Outlook VBA and Custom Forms 1
S Outlook VBA Contacts Notes Outlook VBA and Custom Forms 0
O VBA to Run Font Change on Outlook Startup Outlook VBA and Custom Forms 4

Similar threads

Top