Create from Excel automated email draft in Outlook

General description:
As User
I want to send file which is already created by the existing macro called „Aldi Planung für RCP“ 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: „Werbeplanung“, tab „Planung“
- Existing macro: once the macro button „An RCP Handel“ is clicked, the existing macro is creating and saving a new file named „Aldi Planung für RCP“.
- 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 „An RCP Handel“ in the source file
- to open an email draft in Outlook
- and add the created file „Aldi Planung für RCP“ 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: Aldi DACH Verkaufsplanung Maginon + Rollei - Stand [date of today]

• Email distribution list found in the attached instruction word file

• Email text content:
Liebe Kollegen,
anbei erhaltet Ihr die aktuelle Liste der Maginon und Rollei Produkte Verkaufsplanung für die Aldi DACH Region.