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]

Hi Gordsky

The code is working in that it generates the email but it copies everything from the spreadsheet into the email. It doesn't appear to filter just the records for Defects Date which are 4 months away.

It literally copies all the data into the email.

View attachment 60227

Anything else I can try?

Regards
Sue

It worked when I tested it, Is your info in a table? (rather than cells of the worksheet)? Does the filter range in the code match the date range?
Can you attach a sample of your worksheet

 

[suet]

Hi Gordsky

The code is working in that it generates the email but it copies everything from the spreadsheet into the email. It doesn't appear to filter just the records for Defects Date which are 4 months away.

It literally copies all the data into the email.

View attachment 60227

Anything else I can try?

Regards
Sue

Morning Gordsky

Thank you very much for your help.

Have a fab day.

Take care and regards
Sue

 

[gordsky]

Morning Gordsky

Thank you very much for your help.

Have a fab day.

Take care and regards
Sue

is it working now?

 

[suet]

is it working now?

Hey

Not as needed as I just need to get the records that are due in 4 months and not the whole worksheet.

But thank you as you have helped a lot with the core coding.

Thank you.

Regards
Sue

 

[gordsky]

Hey

Not as needed as I just need to get the records that are due in 4 months and not the whole worksheet.

But thank you as you have helped a lot with the core coding.

Thank you.

Regards
Sue

as i said, the code worked for me in the way you requested when tested so check the dates are actually dates and that they are in the column referred to in the filter within the code.

 

[suet]

as i said, the code worked for me in the way you requested when tested so check the dates are actually dates and that they are in the column referred to in the filter within the code.

Hi Gordsky

I will edit the dates and try running the code again.

Is there anyway I can email you the actual spreadsheet?

Regards
Sue

 

[gordsky]

Hi Gordsky

I will edit the dates and try running the code again.

Is there anyway I can email you the actual spreadsheet?

Regards
Sue

no but you can attach it here using the XL2BB which is the sites method of posting sheets. here

 

[suet]

no but you can attach it here using the XL2BB which is the sites method of posting sheets. here

End of Defects Tracker 15.03.22 - Littlemore (A)_Edited.xlsm
	E
18	A
Sheet1

 

[suet]

End of Defects Tracker 15.03.22 - Littlemore (A)_Edited.xlsm
	E
18	A
Sheet1

 

[suet]

Sorry I have no idea what I am doing here.

Regards
Sue