Open and send an existing mail via an Excel macro

[koltregaskes]

There's quite a few descriptions on how to create a mail, put in a worksheet and send it but I can't figure out from the code how to simply open an existing email (can be either in my Drafts or located on the network - the latter being the preferred option) and sending it.

I don't need to edit or create the mail or attached/adding a worksheet. The email is ready to go, it just needs opening and sending.

Is this possible via Excel macro commands?

[koltregaskes]

Any thoughts on this?

[koltregaskes]

Does anyone have an idea how to do this?

[sarails]

In my opinion you would be better off having Excel create the email "On Demand" rather than open an existing email.
In all the instances that I have used Excel to send emails I have never used an existing email, due to the flexibilty gained by creating the email contents either from code or using cells from a defined sheet area in my workbook.

If I was you I would reasses why you want to use an existing email and if needed rebuild the email format within your Workbook.

Iain

[koltregaskes]

Hi Iain, so it's not possible to open an existing email and send it from Excel? I rather open the existing mail as the links, text and formatting are all ready. I don't need it edited. It can be sent as it is.