DoCmd.SendObject in AC2007

S

Steve S

code has worked for years in AC2000. Migrated to AC2007 and get the message
"Microsoft Office Access can't send this e-mail message". What am I
missing??. Code is:

DoCmd.SendObject acSendReport, strReport, acFormatRTF,
Forms(strForm).Email, , , _
"Confirmation of entry in Baton Twirling Contest", _
Forms(strForm).FullName _
& vbCrLf & vbCrLf & "Thank you for your entry in " & strLinkName & "." _
& vbCrLf & vbCrLf & "If the attached report is not correct please
notify us immediately." _
& vbCrLf & vbCrLf & "Refunds will be returned to you the day of the
contest." _
& vbCrLf & vbCrLf & "Registration for the contest is not complete if a
Balance Due is owed. " _
& "Timely payment of any Balance Due is appreciated." & vbCrLf & vbCrLf
& strMessage1, blnNote
 
A

Arvin Meyer [MVP]

Nothing wrong with the code. Try placing the database in a Trusted Location.
 
S

Steve S

I just double checked and the database is in a trusted location. Code for
other command buttons on this particular form work OK. Could it be something
to do with MSOutlook2007?
 
Top