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
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