Date error in excel to outlook conversion

[Reevu]

Hello

When I run my send email macro, the excel sheet data that populates in the email body has errors in one column.
Eg:
In the workbook the values are reflecting as [TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 128"]3/9/2019 22:00[/TD]
[/TR]
</tbody>[/TABLE]
But in the email body the values are reflecting as
3/8/2015 22:00

Why is this happening and how do I fix it?

Tried but not worked -
Different macros. Getting same error
Converting all formulas to values before running email macro. Getting same error

 

[DanteAmor]

It is an error in office, the same happens when you pass data from Excel to Word using correspondence.
The way I solve it is using an auxiliary column. In your case in the auxiliary column you fill it with the formula:

=text(E2, "dd/mm/yyyy hh:mm")

Then the auxiliary column is the one you are going to send in the mail.

Note: change E2 to the cell with date.

 

[Reevu]

Worked like a charm. Much appreciated.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.