Mailing

[A real begineer]

My application currently emails me tables from site. This is working fine.

My question is can I tell the email to send, without the email appearing in the users window. For various reasons I could imagine the user may not always click to send it, and if they don't my database at this end will not perform correctly.

 

[Atomic Shrimp]

If you're using VBA, presumably you've got a bit of code like:
DoCmd.SendObject acSendTable, "[SomeTableName]", acFormatHTML, [EmailAddress], , , "Email Title", , True

if you change the True to False, the email will be sent straight to the outbox, not opened for editing

Similarly if you're doing the email sending bit in a macro, the SendObject has an argument option called 'Edit Message'

HTH

Mike