How to make a newsletter in aiogram?

Question

SQLite

Unable to send newsletter to every registered user. Sent only to me as an admin.

@dp.message_handler(user_id=admin_id, commands=['tellall'])
    async def mailing(message: types.Message):
        users = db.select_all_users()
        for user in users:
            await bot.send_message(chat_id=message.from_user.id,
                                   text="Тестовая рассылка")
            await sleep(0.3)

Answer 1

Something seems to me that in a line

await bot.send_message(chat_id=message.from_user.id,

should be instead of message.from_user.id - user id from the database.
Let me guess - you get a message as many times as there are users in the database?