auto email to client before 30 days of expiry of loan

[joshynaresh]

Dear Sir,

I'm using access database. i want to code my database so that my database automatically send email notification to client and also to admin of loan expire information ( Expired date and Loan Limit which is already in my database).


Can it is possible? plz help me and provide me also code for it.
Thank You

[AlexHedley]

Have you created a query to find records that meet the 30 day limit?

What version of Access are you using?
2003/2007/2010/...

What email client are you using?
Windows Mail
Outlook 2003/2007/2010/...

Will the computer you use always be on?

What is your programming experience?
Do you know VBA?

[joshynaresh]

no i have no idea about it? i'm using access 2007 and ms outlook 2007. Computer be on Sunday to Friday.
I don't no more about VBA. but i have little knowledge about it.

[Mahendra1000]

So the client should receive the mail before 30 days of expiry of loan....

your system will be OFF on Saturday

For those who needs to receive messages on Saturday.... when u are planning to send messages either Friday/Sunday?

[joshynaresh]

Yes, my client as well as admin also received mail before 30 days of expiry of loan, Yes, System will be OFF on Saturday,
I have planned to send messages when it is reached to 30 remaining of expiry except Saturday.
and I can create query if u guide me.

[AlexHedley]

What have you tried to get the records you need?

[joshynaresh]

I don't understand. can you describe in detail?

[AlexHedley]

You want to create a Query with Loan Limit 30 days before it expires?

So have you thought about how you would write that Query?

If you break it down into steps first.
You need to get Loan Limit so

"SELECT [Loan Limit] FROM table;"
You will need to change the names to what is in your Table.

Next you need to work on limiting the Date by 30. Have you an idea of what is needed as the Criteria?

[joshynaresh]

i have created one query that calculate remaining day of limit to expire. and than what i have to do?

[AlexHedley]

Here's a Tip on how to send a Report as an email, you could amend this to your needs

http://www.599cd.com/tips/access/130...?key=AlexForum

[June7]

Programmatically sending emails is common topic in forum. A search should reveal many examples using various methods. Attempt code for your situation and when you encounter specific issue, post question.

You probably want code to open a recordset of the query, cycle through the records, send email with SendObject method. Review

http://msdn.microsoft.com/en-us/libr.../ff197046.aspx

https://www.accessforums.net/program...ses-37200.html

[ItsMe]

Here's a Tip on how to send a Report as an email, you could amend this to your needs

http://www.599cd.com/tips/access/130...?key=AlexForum

I don't see how this link you provided is of any help, whatsoever.

[June7]

The video demonstrates a very simple interface to email a report as a pdf attachment. It uses wizard to construct button and probably generates an embedded macro. OP is looking for something quite a bit more sophisticated.

[AlexHedley]

I was started off with a simple example to help build the knowledge for the OP as previous posts haven't given the impression of a massive amount of knowledge and giving a chunk of vba maybe overwhelming.
It's better to understand how the whole process works then botch together things found on the web as if there are errors how will the be fixed.

[June7]

I agree, baby steps. That video and the other referenced links should give OP enough to begin learning process.