Results 1 to 4 of 4
  1. #1
    10 Gauge's Avatar
    10 Gauge is offline Getting the hang of it...
    Windows XP Access 2007
    Join Date
    Feb 2011
    Location
    Fredericksburg, VA
    Posts
    202

    E-Mail Query as PDF (need to know how to set landscape mode)


    I have a button for e-mailing a query currently as an Excel spreadsheet however the guy that is using this program much prefers output to PDF without outputting to Excel first and then converting to PDF.

    I have setup the button to just export it as a PDF the only problem is the data does not fit on the page because it's defaulting to a portrait layout. Is there an argument or something that I can use in my embedded macro to specify to output in a landscape format?

    Thanks.

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Are you using a report? If not, I would recommend using a report where it is easy to set the page orientation.

  3. #3
    10 Gauge's Avatar
    10 Gauge is offline Getting the hang of it...
    Windows XP Access 2007
    Join Date
    Feb 2011
    Location
    Fredericksburg, VA
    Posts
    202
    Quote Originally Posted by HiTechCoach View Post
    Are you using a report? If not, I would recommend using a report where it is easy to set the page orientation.
    Wow thanks, yes that was very dumb of me.... I was just e-mailing the straight query, rather than a report based off a query.

    That worked a treat, thanks for the bonk on the head.

  4. #4
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    You're welcome.

    Glad that worked for you.

    Cheers.

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

Similar Threads

  1. Replies: 4
    Last Post: 01-14-2011, 10:37 AM
  2. Using a pass-through query in mail merge
    By ss1289 in forum Access
    Replies: 0
    Last Post: 09-17-2010, 08:58 AM
  3. Access Query mail merge to Word
    By Jan Collier in forum Access
    Replies: 8
    Last Post: 08-30-2010, 09:52 AM
  4. E-mail query
    By Ize in forum Queries
    Replies: 1
    Last Post: 12-09-2009, 09:47 AM
  5. Automating changing Report Print Set-up to Landscape
    By Neil Bingham in forum Reports
    Replies: 0
    Last Post: 12-07-2009, 06:24 AM

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