Bitta Sheets · Part 14 · 2:27 · YouTube
Business Central Schedule Report Email: Send Workbooks Automatically
What this video covers
Send a Business Central workbook by email on a schedule: a sheet distribution renders it as PDF or Excel and sends it to the people you choose, through the job queue.
Set the format, send only when there is data, burst one copy per recipient, add recipients and a subject and body with tokens.
Transcript
Rosa wants the sales analysis every Monday, without asking for it. A scheduled sending takes care of that. Here's how to send a workbook by email on a schedule.
A sheet distribution renders a workbook as PDF or Excel, and emails it to the people you choose, on a schedule, through the job queue. In the workbook, open File and choose Send.
You can send it right away, to users or email addresses, as PDF, Excel or both. Or choose Schedule, and Business Central opens a sheet distribution for this workbook.
Give it a name, pick PDF, and send it only when there's data. Repeat every week. Source type can also be a report pack, built from sections. Burst mode decides who gets what: by a recipient value,
one per recipient, one per dimension value, or one per company. Here, one per recipient. Add the recipients: email addresses, users,
contacts, employees, or a recipient list. The subject and body take tokens, like the date and the recipient's name. Send Now emails everyone on the list. Send Test to Me sends one copy to you only.
Preview renders the file, without sending anything. Check Scheduled Sending lists anything the server can't calculate. Here, nothing stops it. Schedule creates a job queue entry, on hold,
so you can review it first. Set it to Ready, and it runs every week. Its first run is set for the next morning, at six.
Here it is in the job queue, on hold. This test run was log only, so nothing was sent. Every run lands in the log. Use a scheduled sending for the reports people need on a fixed day,
without anyone pressing send. Next, print and PDF: put any workbook on paper.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping