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

Excel Macros Excel Excel VBA

Nº du projet : #33973902

À propos du projet