englandmark
Board Regular
- Joined
- Apr 9, 2015
- Messages
- 62
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:
<tbody>
</tbody>
Again thanks for the help
Mark
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 |
<tbody>
</tbody>
Again thanks for the help
Mark
