Hi experts,
Please can someone guide me with VB Syntax for the following scenario, screenshot attached as reference.
1. If in Column B "Yes" upon pressing email button - automated email is created with the Seller name, simple note i.e. "Here's your sales record" and table created with all from January to Yearly with the relevant numbers in each column.
2. The table I am looking is vertical table in Email body which should look like this :
Month, Sell Days, Sales, Supplies day, Supply, Ratio%
Jan
Feb
etc
Once the email is gone then clear Column B and just put email sent date and time to column BP in the seller line.
I'd really really appreciate your help.
Many thanks.
Please can someone guide me with VB Syntax for the following scenario, screenshot attached as reference.
1. If in Column B "Yes" upon pressing email button - automated email is created with the Seller name, simple note i.e. "Here's your sales record" and table created with all from January to Yearly with the relevant numbers in each column.
2. The table I am looking is vertical table in Email body which should look like this :
Month, Sell Days, Sales, Supplies day, Supply, Ratio%
Jan
Feb
etc
Once the email is gone then clear Column B and just put email sent date and time to column BP in the seller line.
I'd really really appreciate your help.
Many thanks.
