For the life of me I cannot see an option to output the data of a report in the body of an email. Is there some simple setting I am missing in the scheduler? Right now, i have my reports scheduled and being disseminated via email attachment. Is it possible to send the report out in the body of an email as opposed to as an attachment?
Again I am really hoping it is just some setting that I am overlooking in the scheduler. :D
Thanks!
Tyler
Date
Votes
2 comments
-
Jet Reports Historic Posts Yes you can do this - its really handy for sending info without requiring the recipient to open an attachment.
It requires you create a named range for the cells that you want to have included as the body of the report.
(If you aren't familiar with named ranges see primer on http://www.homeandlearn.co.uk/me/mes9p2.html )
Once you've done that use the Jet Scheduler to schedule the report.
Under "E-mail" select the "Message…" button.
Under the "Body" select the button for "Get Body from an Excel Named Range" and choose the named range you want to use.
This also works for the Subject and the Recipients. -
Jet Reports Historic Posts Great, I suspected that perhaps it was something along those line. Thanks, I appreciate the help!
*Update*
One more quick question. I have to use SMTP to send the reports via e-mail as there are issues using the Outlook option where the report doesn't send. Because of this none of the formatting gets carried over in the Named Range when I put it in the email body. It just looks like a bunch of jumbled, unreadable nonsense. Any ideas how to work around this?
Thanks again!
Please sign in to leave a comment.