How to send email automatically when condition met

[azlan]

Hi,
I have inventory database, in database there is "NextScheduledMaintenance" field,
I want access to send email automatically when scheduled maintenance date due.
Can you please help me to do that..

 

[pr2-eugin]

Hello azlan, Welcome to AWF

what would be email that needs to be sent? Does it need the data from the table? How good are you VBA?

 

[azlan]

Hello azlan, Welcome to AWF

what would be email that needs to be sent? Does it need the data from the table? How good are you VBA?

It is simple email that stating; for example " the Crane's maintenance date past due" that is all.

 

[pr2-eugin]

So you want to send separate email to whom is that data derived from the table?

 

[azlan]

Well, email address may be set once in the code. "which is maintenance responsible persons email"
But the main thing is that the email will be sent automatically every time next scheduled time past due for each asset.

 

[azlan]

So you want to send separate email to whom is that data derived from the table?

Can you help me.....

 

[pr2-eugin]

I would love to help you, just you need to be a lot more clearer. You say "it can be set once in code", "when the condition is met". What I need is a description something like,

I have a table - tbl_TryToBeClear, with some columns the columns in question are sometimesYou, haveToExplain, veryClearly, whatYouWant.

From this table I would like to use the exactColumnName, check if they are meeting certain conditions, then I will send an email with all the details of the ones that are expiring.

Something like that, since it is your design I cannot make something up to work. You have to help me to help you here.

 

[azlan]

I changed the way I want to do this.
I want to embed the report in to email body and send the report once a week without clicking any button. Mail is sent when main form is loaded.
Is it possible, if so can you give me some links to point to right direction to;
1. embed report in to mail body then
2. sending that email
3. and automating to be sent once a week when main form is loaded.