How To Send Screen.ActiveForm to Email

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ted Amrine
    New Member
    • Dec 2012
    • 2

    How To Send Screen.ActiveForm to Email

    I Use Win 7 Office 2010 Access
    I wrote the program many years ago, am now 76 and having trouble remembering step 1 by the time I get to step 3.
    I print my invoices, and would like a button with code on invoice page to send Screen.ActiveFo rm to Email1 on the form.

    If it easy I would like to also save a copy to my computer to save on paper with seperate button
    Thank you
    ted
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Ted,
    If your forms or reports are already formatted to print out in the manner you desire, you should be able to simply use the print and the export to PDF buttons available in the ribbon without any coding.

    To Print: With the form currently active: Ribbon: File: Print: (I use the preview just to see how it looks then print from the print preview context ribbon choose which option works for you) or you can simply use <ctrl><p> to go straight to the printer dialog.

    To go to PDF: with the form open and currently active: Ribbon: External Data: Export Group: PDF or XPS and follow the prompts.

    If you really need a button for these steps we'll be happy to help you develop the code etc.

    Comment

    • Ted Amrine
      New Member
      • Dec 2012
      • 2

      #3
      Thank you
      I will do some trying.
      Thank you for the suggestions.
      Ted

      Comment

      Working...