Access freezes

G

Guest

I have a form with a button that opens a report and then
emails it. It works fine as long as it is only one page.
As soon as it is two pages Access freezes and I have to do
an end task. What is going on here? This is my code:

Dim strFrom As String
Dim strTo As String
Dim strCC As String
Dim strSubject As String

strTo = "(e-mail address removed)"
strCC = "(e-mail address removed)"
strSubject = "Special Shipper Request"

DoCmd.SelectObject acReport, "rptSpecialShipper"
DoCmd.SendObject
acSendReport, "rptSpecialShipper", acFormatRTF, strTo,
strCC, , strSubject
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset getRows to string 6
Email Body Blank 1
What is wrong with my code? 4
Email endless loop 4
Email Issue 2
email report per record 1
mulitple attachments with doCmd.SendObject 1
Run-Time Error 438 Outlook 5

Top