Opening a new outlook message via VBA

All-

I am trying to create a command button in Excel that when clicked, it will open up a new Outlook email message, input a certain address in the To: field, and input a specific Subject. The following is the code that I found online earlier today but it does not work when I paste it into the VBA editor.

Please Login or Register  to view this content.

Now, the fact that it is getting an error could be my mistake since I have never created a VBA button before. Is there a basic crash course I can review for doing this and for inputting the code that is needed or can someone summarize it for me. Thank you for all of your help!

Hello ea2004,

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do

it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with

the proper Code tags to create a Code Window in your post.

3. You can also do this manually by placing the tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the line.

just on an aside on the off chance it's of interest you can achieve the same thing with a hyperlink, ie entering the below into a cell and subsequently clicking it will generate the requisite dialog.

mailto:[email protected]&subject=Hello%20World

(the %20 will give you a space)

Try changing this line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.