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

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.

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

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