How do I point the scheduler to a spreadsheet to pull the subject description for an email?
Thank you.
Ashley
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Ashley,
First on the report you are scheduling, you have to create an Excel named range for the cell containing the subject of the e-mail. Then when you create the scheduled task, on the Email tab, click the "Message…" button. You will see a subject field with a drop down arrow. Click the drop down and you will see the list of named ranges in the report. Just pick the named range that you created which contains the subject and you're done! Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
Thank you for your feedback, but, unfortunately, I still cannot get the subject line to appear correctly. I would appreciate you viewing my report to tell me what is wrong with the subject column. I have made N9-N11 the named range of "Subject," which I then select on the drop down box for the subject email message. However, the subject that is shown when the email is received is "UVa Fund Report." I want the subject to change for each of the different reports. For example, I want the subject for the report on line 9 to be "FAA115," and the subject for the line 10 to be "FAAS156."
Thank you for your assistance.
Ashley -
Jet Reports Historic Posts Ashley,
Oh you're using a batch file to do multiple autopilot runs. Similarly to e-mailing itself, you would need to actually use a command line argument on each line to specify a separate subject for each e-mail. The subject argument is specified with /U as defined in the Jet Essentials documentation here:
http://help.jetreports.com/11.0/Essentials/index.html
Does this help?
Regards,
Hughes
Please sign in to leave a comment.