Automated email based on excel cells

[mringrose]

Hi, I am making an automated tracking sheet at work and I want it to send an email 7 days before a job ships (there is a cell with a formula that calculates the amount of time before shipment). I want the body of the email to be comprised of the content of several cells in the workbook. (it basically a giant check list that i want to be emailed to the person who is in charge of checking it.) Is this possible? Would someone mind helping me with the script?

Thanks.