We need to automate an exel document that stores items sold that require servicing. We will input the below fields:Customer Contact Email Tel Site Address Products we service Last service dateService interval (6 / 12mth) - this needs to be radio buttons or dropdown
6 weeks before service is due excel needs to trigger an email to the customer (cc to us also) with our branding, cust name, products that require servicing, when last service was done and when next is due.
We need 3 sheets for 3 different types of product and a slight variation on field names.
Success story sharing