SendObject acSendReport goes nowhere

[Paul H]

Not sure why this isn't working, but when I email a report directly from my form it gets stuck in the Outbox of Outlook.

DoCmd.SendObject acSendReport, "rpt_Letters", acFormatPDF, , , , "rpt_Letters" & _
                                            "_" & Me.txtOrganizationName & "_" & Format(Date, "yyyymmdd") & ".pdf"

You can go to Outlook open the email and click Send, but it still won't go. Clicking Send/Receive doesn't work either, but when I add an email address (mine) and set Edit Message to False, e.g.

                            DoCmd.SendObject acSendReport, strReportName, acFormatPDF, "myEmail@myCompany.com", , , "rpt_Letters" & _
                                            "_" & Me.txtOrganizationName & "_" & Format(Date, "yyyymmdd") & ".pdf", , False

the email goes on its merry way. In all cases Outlook is already running. This has happened to others users on different computers.

Any suggestions?

[Perceptus]

when you invoke this command is there a popup that says something about access trying to send an email on your behalf and are you ok? Think it says "Allow/Deny/Cancel"

[Paul H]

The pop-up only appears when I set Edit Message to False, otherwise the email opens with the attached report waiting to be finished and sent.

[Paul H]

Turns out this is part of a bigger issue. Our version of Outlook is configured not to allow this. I've tried using the "Send" feature on Adobe Reader, Word, Excel and Windows Explorer and all the emails get stuck in the Outbox. Odd how I could sneak one past the sentry with a preloaded Email address and the right switch. I'm not quite sure why "they", the mega corporation that provides our IT services to our IT department, would block this feature, but that's who it's getting pinned on. My next step is to raise the issue with "them" and see if they'll do anything about it. Prospects aren't good, but it's worth a shot.

I'll provide an update when I have one.

[ItsMe]

What is it that Outlook provides that you cannot provide via a form in Access? I say provide whatever features the Users want within a form in Access and then send the thing off on their behalf.

[Paul H]

All my programming is done in my Access form. Outlook is the email client I have to use and it is not allowing the emails to be sent.