I'm new to macros, command buttons, and automated emails. I've been researching the best way to complete this task but seemed to be even more confused on the best way to accomplish this task. I would greatly appreciate any assistance from the experts out there. I'm working on a simple spreadsheet for auto insurance. The cells that will be used in the formulas are first name (column A), last name (B), year (F), make (D), model (E), insurance company (H), expiration date (J), email address (L).

I'm trying to create an automated command button that will send an email on the 20th of each month to employees that meet the criteria making them aware their insurance is set to expire (criteria = 30 days prior to today) or has expired (expiration date past today's date). Below is the email text for 30 days prior to expiration. I would like to set it up to capture the first name, year, make, model, and expiration date in the body of the email. The subject line will read: Auto Insurance - need updated information. I would add a test file, but can't seem to attach the document.

Email Body:

(First Name: $B),

Our records indicate that your auto insurance with (Insurance Company: $H) on the (Year: $F) (Make: $D) (Model: $E) will expire on (Expiration: $J).

To receive mileage reimbursement, company policy states that the owner of the auto must have active auto insurance on any and all vehicles used during company business. Please forward your updated insurance information to Sally Jones, Administrative Assistant at [email protected]. If you have any questions you may contact her at XXX-XXX-XXXX.

Best Regards,

Name