Generate Automatic Email based on Date in Excel doc

[suet]

Hi

I have an excel document that contains Defects Date.

I need to generate an email that will look at the Defects Date and email me 4 months before that Defects Date is dude.

Could someone please advise how I would go about coding this into the workbook.

I would really appreciate any advise/guidance on VBA code that needs to be used.

Kind Regards
Sue

 

[gordsky]

Hiya

I will give the above code a go - thank you.

Ohhh sorry I thought I'd marked it as you had solved it. How do I correct it please to show that you solved it?

Really sorry to be a pain.

Regards
Sue

just re click the tick next to my post

 

[suet]

just re click the tick next to my post

Hey

Have I done it correctly?

Regards
Sue

I really am dumb so appreciate all your help.

 

[gordsky]

Hey

Have I done it correctly?

Regards
Sue

I really am dumb so appreciate all your help.

nope youve still shown yourself. If you click the tick next to post#29 that will do it.....

 

[smozgur]

If you click the tick next to post#29 that will do it.....

I changed the solution post accordingly.

@suet - in the future, that would be great if you could just click on the post that answered the question then it will help future readers. Thanks.

 

[suet]

I changed the solution post accordingly.

@suet - in the future, that would be great if you could just click on the post that answered the question then it will help future readers. Thanks.

Thank you Smozgur.