Hi all, I’m trying to send out emails from access using the SendObject ject acReport, StDocName. This code brings up the email client . SendObject acReport, stDocName, acFormatPDF, _ stRecipients, stDocName = “License CODs” stRecipietns = stRecipients DoCmd. ject acSendReport, stDocName, acFormatPDF, “”,,, “Emailing” & ” ” & strFileName ‘Close the Report acReport.
|Published (Last):||18 September 2016|
|PDF File Size:||16.46 Mb|
|ePub File Size:||9.40 Mb|
|Price:||Free* [*Free Regsitration Required]|
You can’t exit Microsoft Access now.
Page 1 of 2 1 2 Last Jump to page: Results 1 to 15 of Thread Tools Show Printable Version. Join Date Feb Posts Description Select Case Err. Tried various methods; turning off the error description, exiting the sub etc Office Pro Plus 32 bit mix of ACCDE database This was marked as solved on the ” sendobject on cancel error ” however I’m not docmd.sendobjedt sure why or how I dont see the need for ALL this docmd.sendojbect.
Join Date Aug Posts 7, Are you trying to trap an error ?
I can’t send an Access report via email using ject ac. | Microsoft Office Forums
You need to put your error trapping prior to your first Exit Sub line. Originally Posted by ItsMe. Originally Posted by ranman Doesn’t look like I noted it on my initial post. Originally Posted by RyanP. I was able to get this to work in an accdr.
No error or message box or anything. In that scenario, the error appears with your code as well. Made a new DB.
DoCmd SendObject The SendObject action was cancelled. You can’t exit Microsoft Access now.
Error Handling if DoCmd. SendObject is cancelled am fine with giving up on DoCmd. SendObject based on everything i’ve read on it. Not a bid deal though. I guess I can just use the OutputTo acReport to a predefined location and use it as the attachment.
I will work up some examples after I get qcreport sleep. Email Example with Automation of Outlook This code seems to work good as a standalone. I did not have any issues with warnings, security or otherwise.
SendObject report with a filter
Email sent via DoCmd. SendObject By silverback in forum Programming.
SendObject Help By bgreer in forum Programming. All times are GMT The time now is