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:
Date Customers Name Address Phone number Call information salesman
6/24/19 Jim Buy Shop Road 912-812-2345 Need to get an estimate Roger Getem
6/24/19 Sue Sell Store Street 912-812-1234 need to book service Tim Sold


Again thanks for the help
Mark