This is the way that I am doing it now:
==============================================
DoCmd.OpenReport stDocName, acPreview, , "[ID] =" & Me![ID]
DoCmd.SendObject acReport, "New User Report", "SnapShot Format", _
"my.name@work.com", , , "User Request Form", "User Request", False
DoCmd.Close acReport, stDocName
==============================================
Is there away to get it to send without having to open the report up first??
I would like to remove the 1st Docmd.OpenReport and the last Docmd.Close acReport command and still have it send the correct form ID.
==============================================
DoCmd.OpenReport stDocName, acPreview, , "[ID] =" & Me![ID]
DoCmd.SendObject acReport, "New User Report", "SnapShot Format", _
"my.name@work.com", , , "User Request Form", "User Request", False
DoCmd.Close acReport, stDocName
==============================================
Is there away to get it to send without having to open the report up first??
I would like to remove the 1st Docmd.OpenReport and the last Docmd.Close acReport command and still have it send the correct form ID.