Create from Excel automated email draft in Outlook II

General description:
As User
I want to send file which is already created by the existing macro called „Mickeleit_Orders “ automatically, to a certain email distribution list.
To avoid every single time manually creating a new email, adding the file, adding the recipients and the text.
Background information:
- Source File: „Supra Ausland Bestellungen “, tab „Supra n. Lief u Order “
- Existing macro: once the macro button „Export Mickeleit“ is clicked, the existing macro is creating and saving a new file named „Mickeleit_Orders “.
- This existing works good and shall work same after the update.
New task:
- Add to the existing macro
- initiated by the existing macro command button „ Export Mickeleit“ in the source file
- to open an email draft in Outlook
- and add the created file „ Mickeleit_Orders “ into the email draft
- and add the below distribution list
- and add the below text into the email draft
- and set the below email subject
END. That’s it. The email should be sent out manually by the user. No auto sending please.

Email Details:
• Email Subject: Supra Vorankündigung Verkaufsaktionen_Aldi Nord – (date of today)
• Email distribution list: TO: see in attachement
• Email text content:
Sehr geehrte Damen und Herren,

in der Anlage erhalten Sie die Vorankündigung unserer Aldi Nord Verkaufsaktionen. Die fehlenden Unterlagen wie B/L und Packliste, sowie die Abnahmedaten erhalten Sie wie besprochen im Nachgang.

Bei Fragen stehen wir Ihnen jederzeit gerne zur Verfügung.
Vielen Dank