A macro capable of creating an email in the default email client

[nbelal]

Hi Everyone,

I need an Excel VBA macro, that is capable of preparing an email to be sent in the installed email client (not necessarily a Microsoft product, and could be on a PC or a MAC computer), with the email address to send and email subject already filled.

Best regards,
nader Belal

 

[smozgur]

Welcome to the board!

Try the following.
It might not be the perfect method but could be the easiest one to define the email address and subject when it comes to multiple OS and unknown email clients. Even the body could be passed as a parameter if necessary.

Activeworkbook.FollowHyperlink("mailto:test@email.com?subject=here is the subject")

 

[nbelal]

Welcome to the board!

Try the following.
It might not be the perfect method but could be the easiest one to define the email address and subject when it comes to multiple OS and unknown email clients. Even the body could be passed as a parameter if necessary.

Activeworkbook.FollowHyperlink("mailto:test@email.com?subject=here is the subject")

That is exactly what I was looking for ... Thank you.

Can I invite you for a cup of coffee ??

 

[smozgur]

That is exactly what I was looking for ... Thank you.

Can I invite you for a cup of coffee ??

Great to hear it helps.
Thank you

Note: Please consider marking the solution post in your questions as it would help future readers who might have similar questions.

 

[nbelal]

Great to hear it helps.
Thank you

Note: Please consider marking the solution post in your questions as it would help future readers who might have similar questions.

Done, and thank you again