Excel Macro Email functionality (macro) help

If (ActiveSheet.ComboBox1.Value = "YES") Then
                Range("K13").Select
                iRow = "RUSH - Corporate Vendor Request - " & ActiveCell & " - " & ComboBox2.Value
                ActiveWorkbook.SendMail Recipients:="---@---.com", Subject:=iRow
                MsgBox "Vendor Request email sent to vendor.management@---.com!", vbInformation, "Email Sent"

Hi all!

I've got the above code. However, the code is automated and it sends email to the specified email address. What I want is, the composed message to appear (or displayed) and the user is to send the email (by manually pressing the send-button)

I've checked this thread out but I do not know how to make the email to display on screen.

http://www.excelforum.com/excel-prog...-not-send.html

Any help is much appreciated!

Thanks!

Any help on this please?

Thanks!