We help IT Professionals succeed at work.
Get Started

The sendobject action was cancelled

iainmacleod
iainmacleod asked
on
1,088 Views
Last Modified: 2013-11-28
I am using a button to send an email and have the problem when closing the email rather than sending.
I cannot seem to figure out other code examples found so hoped that by showing my modest code might persuade someone to offer me a little assistance.
Thanks in advance.
Private Sub emailcertcmd_Click()

Dim dbs As Database, customers As Recordset, certemail As Variant, stDocName As String
Set dbs = CurrentDb
stDocName = "Main Certificateemail"
Set cust = dbs.OpenRecordset("customers", dbOpenDynaset)
On Error Resume Next


cust.MoveFirst
    Do Until cust.EOF
        If Me.Accno = cust![Account No] Then
            certemail = cust![certemail]
        End If
            cust.MoveNext
    Loop
   
DoCmd.SendObject acSendReport, "Main Certificateemail", acFormatPDF, certemail, , , "Your Freightnet (RASCO) Ltd REST Certificate is attached", "Please find your Certificate attached", True
DoCmd.RunMacro ("main printcert")
db.Close
Set db = Nothing
End Sub
Comment
Watch Question
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE