How to send mails using Code without opening Outlook

[AR Ratheesh]

Hi Guys,
Need help to sent mails using code.i have a table containing 2 fields 1.Name,2.Email ID.and an another table(Data to be attached).

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
 
    DoCmd.SendObject acTable, "Table1", "MicrosoftExcelBiff5(*.xls)", "[e-mail]", "", "", "trail", "", False, ""
 
Exit_Command0_Click:
    Exit Sub
 
Err_Command0_Click:
    MsgBox Err.Description
    Resume Exit_Command0_Click
 
End Sub

But this will shows the Outlook.I dont want to show Outlook and sent mailing process should be in background...
Please help me...
thanks in adv.

[ajalwaysus]

I don't know about MS Access 2007, but I have extensively researched emailing from MS Access 2003, and the issue is that if you want to be able to send an email without Outlook popping up, the only way i know of is if you can use your company's "SMTP Mail Host". If you can get that, then I can walk you through how to use that to email with CDO.

This is much more technical, so let me know if you wish to go forward with this.

-AJ

[NeoPa]

Please notice the edit comments. You must post code using the tags in future.