Skip to content
Bitta Apps

Chapter 4 of 4Page 3 of 4

Share and distribute

Send workbooks on a schedule

Email a workbook as PDF or Excel on a schedule: set the recipients, the burst mode and the email, preview the file, then schedule it through the job queue.

updated: applies-to: 1.0.0.0

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. Use it for the reports people need on a fixed day, without anyone pressing send.

Send now or schedule from the workbook

In the workbook, open File and choose Send. Send it right away to users or email addresses, as PDF, Excel or both, for this sheet or all sheets. Or choose Schedule, and Business Central opens a sheet distribution for this workbook.

Send dialog from the File menu of the Sales Analysis workbook with To, Subject, Format and the Send and Schedule buttons

You can also open Sheet Distributions from Tell Me and choose New. Starting from the workbook fills in the workbook for you.

Set up the distribution

  1. Give it a description and choose the Output Format: PDF, Excel, or both.
  2. In Send, choose Always, Only When There Is Data, or Only When a KPI Needs Attention.
  3. In Repeat Every, set how often it runs, for example every week.
Sheet Distribution card for a Monday sales pack: workbook source, PDF output, send only when there is data, repeat every week

The Source Type can be a workbook or a report pack built from sections.

Filter Values sets the filter cells of the workbook and the values they take when the distribution runs, for example last month. Date formulas are evaluated on the run date.

Recipients and bursting

Burst Mode decides who gets what: By Recipient Value, One per Recipient, One per Dimension Value or One per Company. With One per Recipient, every recipient gets their own copy.

Add the recipients on the Recipients lines: an email address, a user, a contact, an employee, or a recipient list. Recipient Lists keeps a reusable list of people, with lines per company and dimension value, and Check Recipients shows anyone who can't be reached, such as a user without an email address.

Sheet Distribution with burst mode One per Recipient, two email recipients, and a subject and body with tokens

The email

The Subject and the body take tokens such as &[Title], &[Company], &[Date], &[Recipient], &[BurstValue] and &[Slicer:C2]. Leave the body empty for a short standard text.

  • File Name names the attached files. Tokens are allowed; leave it empty to use the title.
  • Keep Attachments keeps a copy of each sent file in the log, so it can be downloaded or resent.

Emails go through Bitta Apps Studio, which uses a Business Central email account. An administrator chooses the account in Studio Email Setup.

Preview and check before it runs

Preview renders the file without sending anything.

PDF rendered by Preview with the sales analysis tables, without sending anything

Check Scheduled Sending lists anything the server can't calculate in the workbook, such as an unsupported function, a circular reference or live data that fails, before the distribution runs from the job queue. You can also run it from Workbook Properties.

Check Scheduled Sending message saying that nothing stops this workbook from being sent on a schedule

Send Now emails everyone on the list. Send Test to Me sends one copy to you only.

Schedule it

Schedule creates a recurring job queue entry with the status On Hold, so you can review it first. The Earliest Start Date/Time shows when it first runs. Set the entry to Ready when you want it to run.

Job Queue Entry created by Schedule for the distribution, with status On Hold and the earliest start date and time

The log

Log lists every run of the distribution, one line per recipient, with its status. When Keep Attachments is on, you can download a copy of a sent file or send it again.

Sheet Distribution Log with two runs of WB-0001, one per recipient, with the status Not Sent, Log Only

NOTE

While email is in Log Only mode, runs are logged as Not Sent (Log Only) and nothing is emailed until an administrator changes that.

What's next

More in Share and distribute.

Next step

Ready to try Bitta Sheets?