Skip to content
Bitta Apps

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

Next step

See Bitta Sheets on your own data