VBA email help

[englandmark]

Hi all, thanks for the help in advance
Code needed for the following
Automatically daily at 6 a.m
Email Columns A(Date), D(Customer Name), F(Address), G(Phone number) & K(Call information) all rows with yesterdays date
Add another column at the end(Salesman) and leave cell blank
Data to be a table with grid lines
Sheet name call log, date is in column A.

Example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Customers Name[/TD]
[TD]Address[/TD]
[TD]Phone number[/TD]
[TD]Call information[/TD]
[TD]salesman[/TD]
[/TR]
[TR]
[TD]6/24/19[/TD]
[TD]Jim Buy[/TD]
[TD]Shop Road[/TD]
[TD]912-812-2345[/TD]
[TD]Need to get an estimate[/TD]
[TD]Roger Getem[/TD]
[/TR]
[TR]
[TD]6/24/19[/TD]
[TD]Sue Sell[/TD]
[TD]Store Street[/TD]
[TD]912-812-1234[/TD]
[TD]need to book service[/TD]
[TD]Tim Sold[/TD]
[/TR]
</tbody>[/TABLE]


Again thanks for the help
Mark