Send Object (Routine e mail)

[Ramu]

Hi

Can anybody help me to send a routine e mail without the warning message ( set off warnings- is not working) - How to offset the system message.

I am not familier with VB, can anyone help with details if possible with a example

Please

Regards
Ramu

 

[jeremie_ingram]

The command to turn the warnings off is DoCmd.setwarnings = false.
Be sure to have this in the code BEFORE the command that triggers the warning.

 

[Ramu]

Send Object (Routine E Mail)

Thanks for the mail but I am not sure- the following code I copied- can you help where I have to paste - Please

Private Sub Command29_Click()
On Error GoTo Err_Command29_Click

Dim stDocName As String

stDocName = "Addendum Report"
DoCmd.RunMacro stDocName

Exit_Command29_Click:
Exit Sub

Err_Command29_Click:

MsgBox Err.Description
Resume Exit_Command29_Click

End Sub


Thanks
Ramu

 

[Mile-O]

I have no idea what your Macro's properties are but this should suffice:

Private Sub Command29_Click() 
    
    On Error GoTo Err_Command29_Click 

    Dim stDocName As String 

    stDocName = "Addendum Report" 
    With DoCmd
        .SetWarnings False
        .RunMacro stDocName 
        .SetWarnings True
    End With

Exit_Command29_Click: 
    Exit Sub 

Err_Command29_Click: 
    MsgBox Err.Description 
    Resume Exit_Command29_Click 

End Sub