Some Access Runtime users can't email Access reports

Question

I have several users running an Access 2007 application installed using Runtime. In the application is a report that is intended to be emailed. Clicking a button on the form opens the report in Preview mode. Clicking another button on the form will, for many, email the report as an attachment.

Some people have no problem sending this report via email. For others, however, the email has no send button OR it seems to be sending from a non-existent email source.

Has anyone had this experience and been able to solve it? Any advice would be welcomed.

Thank you.

Answer 1

No SMTP is a replacement for SendObject.

http://www.utteraccess.com/forum/Sending-Email-SMTP-CDO-t1957295.html

Answer 2

I'm sorry it has taken me so long to reply. (Life has been intervening in a BIG way recently.)

You are, of course, correct in assuming I'm using SendObject. Here is my code:

Private Sub cmdEMAIL_Click()

On Error GoTo cmdEMAIL_Click_Err

        'Save the record if needed

    If Me.Dirty Then Me.Dirty = False

    DoCmd.SendObject acReport, "rThisRecipMeas", , , , , , , True

cmdEMAIL_Click_Exit:

    Exit Sub

cmdEMAIL_Click_Err:

    MsgBox Error$

    Resume cmdEMAIL_Click_Exit

End Sub

I did try rewriting the DoCmd, but there was no STMP on the list, and the only "Send" statement I saw on the drop down list was SendObject.

Can you help me make this work with web based emails?

Thank you for any help you can offer.

Answer 3

Outlook Express hasn't existed for years. I'm assuming you are using SendObject to send e-mails? You might consider using SMTP.

Answer 4

I honestly don't know what they are using as their email client. The only thing I know for sure is that they are using Windows. That's why this is a Runtime application.

I have Outlook on both of my machines (desktop and laptop.

Is there a solution for people without Outlook as their mail client? Is Outlook Express bundles with Windows, and can that be used?

I'm set to go public with this program tonight, and I'd really like to solve this problem before I misrepresent this program to people.

Thanks for anything you can do to help.

Answer 5

Are they all using Outlook as their e-mail client?