Date error in excel to outlook conversion

Reevu

New Member
Joined
Mar 9, 2019
Messages
3
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
3/9/2019 22:00

<tbody>
</tbody>
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
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.
 
Last edited:

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
I'm glad to help you. Thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,263
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top