Using DoCmd.SendObject to send on a certain date

[jase2006]

Hi, I am currently using the function below to send a report through email. I would like to know if I can delay the sending date to the next day?
***************************************************
DoCmd.SendObject acSendReport, ReportName,acFormatRTF, Email1, Emal2, "Report1", Me.txtEmailNarr, False
****************************************************

Thanks

 

[Remou]

With SenObject, you would need to use the database to delay sending, that is, add a ToBeSent table with dates. Otherwise you will need to use Outlook automation, or such like.

 

[jase2006]

ok thanks, So how I do I use the database to do this. some code sample would be great

Thanks again

 

[Remou]

Add the required details to a table. Examine the table either on opening the database, or periodically using a background form and timer. If a mail is found with the required date and time, notify the user and send the mail.

 

[jase2006]

Right I get it now.

Thanks a lot Remou