Specifically, I would like to email the individual page (or text) that is created in a report as the result of a completed form. I can't use SendObject b/c I don't want to send the entire report (it's hundreds of pages), just an individual page.
Perhaps the best way to describe it is through the OpenReport Cmd:
DoCmd.OpenReport "RetAuthFrm", acViewNormal, "", "[ttnum]=[Trouble Ticket Number Please:]"
This works great for printing b/c the "where" clause let's you specify the report page. If this allowed me to output the result to an email it would be the ideal solution. Unfortunately, this command doesn't have an option that let's you email instead of print (At least that I'm aware of).