I have a form that allows the user to select to preview then print a report. I have just been informed that the user is sending the reports via email. The reports are in landscape format, however, the email sends the data via portrait format thus cutting off a major portion of the report. Is is possible to create a button in the form for the person to select and email the report (previewing would be nice but not necessary) And if so setting the page orientation to defaul to landscape?
Thank you for your help on this matter
Robert M
PS In my searching I have come accross the VBA code for sending your report to Email that is...
Private Sub cmdEmailRpt_Click()
On Error GoTo Err_cmdEmailRpt_Click
Dim stDocName As String
stDocName = "CPEReport"
docmd.SendObject acSendReport, stDocName, , , , , , , -1
Exit_cmdEmailRpt_Click:
Exit Sub
Err_cmdEmailRpt_Click:
MsgBox Err.Description
Resume Exit_cmdEmailRpt_Click
End Sub
Problem is that it does the full report and not the individual I am wanting, also it does not present it in Landscape mode.
Anyone have any ideas on how to solve this? I'll keep researching and testing.
Thank you for your help
Robert M