Send Email From Excel With VBA

[GandalfTheWhite]

I have found loads of code to send an email with VBA but I want the code to just prepare the email and set Outlook in focus for them to possibly amend before the email is sent.
I can use ".save" in the With Outmail, but really want the code to prepare the email.

Can anyone point me in the right direction?

Thanks,

GTW.

 

[Misca]

Have a look at Ron de Bruin's website:

http://www.rondebruin.nl/sendmail.htm

 

[GandalfTheWhite]

Thanks Misca, I have seent his but every example seem to cover "Sending" the email, and I need a way to prepare it for review/amendment before the user Sends manually.
I can't seem to find anything in Ron de Bruin's.

GTW.

 

[Misca]

Take a look at the first Example on

http://www.rondebruin.nl/mail/folder3/smallmessage.htm.

Try replacing the ".Send" with ".Display" and you'll see the message and can edit it but you'll have to send it manually.

 

[GandalfTheWhite]

.Display!!!!!!!!!!!!!!!!! Genius Misca.
That is exactly what I was looking for.

thank you, thank you, thank you.

GTW.

 

[GandalfTheWhite]

I'm such a fool

.Send 'or use Display!!!! Doh!

Thank you for your clever eye Misca.