Unpublished events end up in the newsletter agenda

One-sentence description

Current behaviour / Reproducing the bug

When you create a newsletter and there are unpublished events in the next two weeks they will be included in the newsletter.

Expected behaviour

Unpublished events should not be included.