Skip to main content

E-mailing a report on a schedule

How to e-mail a saved report from My Reports automatically, with current data and an Excel, CSV or PDF attachment, on the days and times you choose, to people, branches, departments, positions and addresses outside the company; and how to pause, test…

This article explains how to e-mail a saved report from My Reports automatically, with current data, on the days and times you choose. For example, last week's leave report goes to the branch managers every Monday at 08:00, and each branch manager sees only their own branch. Users with Report scheduling set up and manage their own scheduled e-mails; users with Report Module Responsibility Management see and manage every scheduled e-mail of the company.

Each recipient gets the report prepared with their own permissions; the permissions of the person who set it up do not pass on. Someone without a report permission (View Report List, Add Report List or Report Module Responsibility Management) gets no e-mail. A report that reads the salary and payroll tables goes only to recipients with View Salary or Payroll Manager Permission. Identity number and phone columns are masked by the recipient's permissions, as on screen.

Before you start

  • You need Report scheduling or Report Module Responsibility Management, together with a report permission (Reports module overview). To add addresses outside the company you also need E-mail reports outside the company (nobody has it by default) or to be the company administrator.

  • The report must be saved in My Reports (Creating a custom report). If the report should use the current range on every sending, use the Relative date operator (e.g. Last week) in its date condition; a condition with fixed dates returns the same dates every time.

Step by step

  1. From the left menu go to Reports > My reports.

  2. Click the send icon (Send automatically) on the report's row. If the report has no scheduled e-mail yet, the Scheduled e-mail window opens; otherwise the report's list of schedules opens and you add one with New schedule.

  3. Under Frequency choose Daily, Weekly or Monthly.

    • Weekly: pick one or more Days (e.g. Mon).

    • Monthly: under Which day of the month choose A day of the month and pick the Day of month (shorter months use their last day, e.g. 31 sends on the 28th in February), or choose First working day of the month or Last working day of the month (weekends and public holidays are not working days).

  4. Pick the sending Time in 15-minute steps; the default is 08:00. Time zone is Company time by default (the time of your company's country, Turkey time for most companies); choose another city if the recipients work in another time zone.

  5. If you like, turn on Do not send at weekends and Do not send on public holidays. A sending that falls on a public holiday is not made and shows as Skipped in the history. Limit the period with Start date and End date; leave the end date empty to send with no end date.

  6. Check the date and time of the next three sendings under Next sendings. Those on a public holiday are struck through with Public holiday, skipped.

  7. In Recipients choose one option under Send to:

    • Specific people: pick the recipients in the person picker. The branch, department and position fields only help you find people. The people you choose stay fixed; people who join later do not get it.

    • Branch / department: pick branches and, if you like, departments. If you choose departments it goes only to them; otherwise to every employee of the chosen branches.

    • Position: pick positions, for example every branch manager. It goes to the people holding the position at each sending.

    • Branch, department and position lists are resolved to the current employees on every sending: newcomers start getting the report, people who left or changed position get nothing.

    • To send outside the company, type the address under E-mail addresses outside the company and click Add. The first time, a window asks you to confirm; click Yes, add. Remove an address with the cross next to it.

      Confirming an outside address
    • Below it says "Goes to N people today". At most 100 people and addresses can receive it. People without a report permission are named in a yellow warning, people who left this delivery with the link in its e-mail in a blue note; neither gets an e-mail.

  8. Under Data scope choose who sees what:

    • Each their own branches (default): each recipient gets only the rows of the branches they are responsible for (branch responsibility); a branch manager sees their own branch. The company admin and people responsible for every branch get every row.

    • Everyone the whole company: each recipient gets the rows of the whole company, as in My Reports.

      Recipients and data scope in the schedule form
  9. Under E-mail content choose Excel (.xlsx), CSV or PDF as the Attachment format (a PDF holds at most 5000 rows). With Show the first rows in the e-mail on, the e-mail body shows the first 10 rows of the report. With Send even when the report is empty off, no e-mail goes out when no record matches the conditions.

  10. If you like, write your own E-mail subject and E-mail message. You can use the variables {rapor_adi} (report name), {tarih_araligi} (the report's date range on that sending), {sirket} (company) and {alici_adi} (recipient's first name). Left empty, the subject is "Your report is ready: report name".

  11. Click Save.

Managing schedules

  1. Click Scheduled e-mails at the top right of My Reports. The scheduled e-mails are listed with their report, When, Recipients, Last sending and Status; with Report Module Responsibility Management you see every one of the company, with Report scheduling only yours. To see one report's schedules, click that report's send icon.

    Scheduled e-mails list
  2. The history icon (Delivery history) on a row shows every sending and its result per recipient, with the reason when it did not go.

    Delivery history per recipient
  3. In the row menu (⋮):

    • Edit: change the frequency, time, recipients, scope and content.

    • Pause / Resume: stop the schedule for a while or start it again. Sendings missed while paused are not made up for.

    • Send now: e-mails the report to every recipient right away without waiting for the schedule; see the result in the history.

    • Send me a test: e-mails the report only to you, with your permissions and scope, right away. Use it to see what recipients will get.

    • Delete: deletes the scheduled e-mail. The report stays.

Result

  • Within a few minutes of the sending time every recipient gets a separate e-mail with the report's name, its date range, the number of rows, your message, the first rows if you chose so, and the full report attached. Open the report in Teamso opens it in My Reports.

  • Dates in the file are in Turkey time and coded fields (e.g. leave status) are written as text. A report over 10 MB is not attached; the e-mail links to the report in Teamso instead, where the recipient sees it after logging in, with their own permissions.

  • An address outside the company gets the report prepared with the permissions and branch scope of the person who set it up; salaries, identity numbers, phones, health, disability and criminal record details, leave types that tell health, pregnancy, disability, union or religion (such as sick or maternity leave) and texts people wrote (leave reasons, notes) are hidden, and there is no Teamso link.

  • At the bottom of every e-mail, I do not want to receive this scheduled report opens a page where the recipient leaves only this delivery with Leave the delivery. A person can also turn off every Scheduled reports e-mail under Notification settings > E-mails.

Leaving a scheduled report
  • If sending to a recipient fails, it is tried again after 5, 15 and 45 minutes. If it still fails, the person who set up the schedule gets an in-app notification and an e-mail.

  • If you edit the report, its scheduled e-mails send the new version from then on. If you delete the report, its scheduled e-mails are deleted too.

  • If the person who set up the schedule leaves or loses the scheduling permission, the schedule pauses by itself (Owner left / Owner lost permission) and the company admin gets a notification and an e-mail. Whoever clicks Resume becomes its new owner.

  • Every change to a schedule and every sending (who, when, to whom) is written to the system log.

Statuses in the delivery history

On screen

Meaning

Sent

It reached every recipient.

Partly sent

It could not be sent to some recipients even after the last attempt.

Not sent

It could not be sent to anyone.

Will retry

A sending failed; it is tried again at the time shown next to it.

Skipped

Public holiday, no recipient, nobody to send to (no permission or empty report), or every recipient is a test address (e.g. example.com).

Recipient rows show Sent, No report permission, Empty report, Skipped and Error, with the reason below the name (e.g. Left this delivery, The person turned these e-mails off, The person who set it up may not send outside the company).

Common problems

Symptom: I don't see the send icon (Send automatically) on the rows or the Scheduled e-mails button.
​Cause: You have neither Report scheduling nor Report Module Responsibility Management.
​Fix: Ask your company administrator for the permission.

Symptom: A recipient's row says No report permission.
​Cause: The person has no report permission, or the report reads salary data and the person may not see salaries.
​Fix: If the person should get the report, give them the permission; otherwise remove them from the recipients.

Symptom: A branch manager's report is empty or misses some branches.
​Cause: With Each their own branches a person gets only the branches they are responsible for; their branch responsibility is missing a branch.
​Fix: Add the branch to the person's branch responsibility, or choose Everyone the whole company if everyone should see every branch.

Symptom: I cannot add an address outside the company.
​Cause: You do not have E-mail reports outside the company.
​Fix: Ask your company administrator for the permission; you can still remove addresses already on the schedule.

Symptom: Every sending holds data of the same dates.
​Cause: The report's date condition was saved with fixed dates.
​Fix: Open the report with Edit, choose the Relative date operator in the date condition and save (Editing a saved report).

Symptom: "At most 100 people can receive it; choose fewer recipients."
​Cause: The people, branches, departments, positions and addresses you chose come to more than 100 recipients.
​Fix: Narrow the recipients or split the report into several schedules.

Related articles

Did this answer your question?