How are you accomplishing the emailing? Are you opening the report, right clicking ti, or using code?

I added a command button to the form...

 

Here is the code generated by the wizard....

 

Private Sub MarineRetail_Click()
On Error GoTo Err_MarineRetail_Click

    Dim stDocName As String

    stDocName = "Marine Retail Price List"
    DoCmd.SendObject acReport, stDocName, , , , , "Tiger Performance Products - Marine Retail Price List", "Attached is the Marine Retail Price List."

Exit_MarineRetail_Click:
    Exit Sub

Err_MarineRetail_Click:
    MsgBox Err.Description
    Resume Exit_MarineRetail_Click
   
End Sub

 

Works great  with Outlook 2003 - problem is with Outlook 2007...

 

Thanks

 

Could you change the line

 

Err_MarineRetail_Click:
    MsgBox Err.Description
    Resume Exit_MarineRetail_Click

To read

 

Err_MarineRetail_Click:
    MsgBox Err.Description & Err.Number
    Resume Exit_MarineRetail_Click

Let me know if a number is generated

Allan - it returns error code 2293...

 

thanks

 

This is due to the Email security setting in Outlook 2007. Have your IT person look at the settings, or refer to the KB article << here >>

 

 

Allan - we use AOL for e-mail and Time Warner is our ISP....

 

I have set up Outlook 2007 to access the AOL server...

 

thanks

 

Yep....that's the problem...

 

Is there any way to uninstall that patch?

I'm going to assume you're using Exchange Server for your email. I'll look into this and let you know what I find.

OK. I just figured with 10 PC's you'd be using server software for email.

 

One question - how do you set up Outlook 2007 for AOL? I;m curious as I've never had any of my clients able to accomplish this.

 

I'll let you know what I find about the problem.

Allan - yes - in the past that was quite difficult for me also (setting up Outlook to use AOL)...

 

Outllook 2007 did all the work for me - I just chose to set up a new account - gave it my e-mail address - and it went out and found all it needed - must have used the @aol.com domain name...

 

Came back with the incoming and outgoing AOL server names and I was set to go...

After doing much research, it appears you're stuck with the problem, as there is no way to fix the email security issue in Outlook 2007 unless you're using Exchange Mail Server. However, on my PC, the command button to send via email works fine.

 

If possible, could you send me a copy of the database and I'll try it. If it works, then I'll assume there is an issue with AOL in Outlook 2007. (If the database is split into front and back end, I would need both files)

 

If you cannot send me a copy, can you try another email account?

Allan - are you running Outllook 2007 and it works???

 

The database is 15MB - would you know of an FTP site to use?

 

thanks

 

Yes, I have Outlook 2007 and Access 2007 and no problem.

 

Have you compacted the database? (Office button, Manage, Compact and Repair) It may reduce the size. Otherwise, can you just give me the structure and no data? You can do this by creating a blank database and importing the tables, forms, reports, etc from your working database. Just choose the External Data tab, Import ribbon, Access. Make certain to choose the options button and mark Definition Only to import the objects without data.

 

If this is too much, let me know. Also, if you email it, you must compress the file into a zip file, as email will not allow Access files.