Email Record Question

GregSmith

Registered User.
Local time
Today, 14:58
Joined
Feb 22, 2002
Messages
126
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.
 

Users who are viewing this thread

Back
Top Bottom