Results 1 to 2 of 2
  1. #1
    Robert M is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    23

    Email with proper page orientation of Report

    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
    Last edited by Robert M; 08-04-2009 at 04:02 PM. Reason: Found VBA Code that meets part of my need

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Check out this thread from dbforums:
    http://p2p.wrox.com/access-vba/24279...ls-access.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Email a report of the current record.
    By jonudden in forum Reports
    Replies: 4
    Last Post: 08-21-2023, 07:37 AM
  2. Emailing report at the Email content
    By ylivne in forum Reports
    Replies: 0
    Last Post: 07-07-2009, 05:31 AM
  3. Email Report for each Vendor
    By dennisg in forum Reports
    Replies: 0
    Last Post: 09-29-2008, 02:43 PM
  4. Another email report question ...
    By valkyry in forum Reports
    Replies: 0
    Last Post: 05-23-2007, 11:42 PM
  5. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums