I want to keep the time of received mail in Outlook and keep the data in Excel, what should I do?

Hi @Famui_Yanisa ,
You can extract the date from the email as a DateTime variable type with EmailReceiveTime = CDate(mail.Headers(“Date”)), and then simply covert that received date into the time format you need, like this: EmailTime = TimeEmailReceived.ToString(“HH:mm”) …
Then add 1 columns "Time received "in Excel to write

my output

my step:
-create file to save mail and time
-get list mail
-for each mail to get body and time
-write cell to write value of body and time to excel file


I sent xaml file and ouput file, you can try it
Hope it help
Regards,
LNV

3 Likes