INTRUCTIONS



A :You need to configure your E mail account in Outlook before using the program.
b:To Disable Outlook Warning about a program accessing the outlook to send a mail
Open outlook 2010 > File > Options > Trust Centre > Trust Centre Setting > Programmatic Access >
Check at "Never Warn me about Suspicious Activity" to stop warnings. > Ok > ok . Close Program to activate seting.
Copy and Paste data.doc and data.xls in D:\ (Root dir of D drive)
These file will be attached in E mail.
1:Open the DB will run AutoExce to run. It will Open EMail_Form with the massage to confirm sending of mail directly
with deafult massage/Subject ( Can be Modified in design window of query)
2: Click modify tab To Edit Subject and Massage Body and than send a common massage to all.

3:The mailsare send as per data available in DATA table. Edit It with real data and Test it.
4: The E mail data is filtered in Renewal_Reminder_Query as WHERE (DATA.Date_of_Renewal)=Date().
(E mail Having Today as Date of Renewal will be Send. You can Pre-pone by modifying code as WHERE
(DATA.Date_of_Renewal)=Date()-5 to send mail 5 day earlier.

5:I had used Module Send_The_Mail_Form in form
If you want massage of confirming E mail And Renewal date of each mail than remove a 'before two lines eg
'MsgBox "The Email is Sucessfuly send to " & strField1
'MsgBox "The Date Of Renewal is due on " & intField3
7: If you want to send Report (REMINDER_REPORT) as attachment the Replace Send_Mail() in place of Send_EMail_Form ()
in AutoExec macro.
Auto Schedule The Email at Specified Day And Time.
E mail can also be send at designated date & time as follow.
Copy and paste "Shortcut to AutoExec in automate E mail.accdb".
at D:\ (Root dir of D drive)
Run to check it.
add it to scheduled task as follow.
Control panel > Scheduled Task > Add Scheduled Task > Next > Browse > Select Short Cut File at D:\Shortcut to AutoExec in automate E mail.accdb > Next > Daily > Specify Time, Everyday, Startday As Today > Next > Specify Admin User Name and Password > Next > Finish.
It will Automatically Send E mail at Everyday at Specified time.