Start Outlook from within a spreadsheet

[hiker8117]

I looked on the web however I could not find any answers.

Is it possible to start Outlook with a hyperlink within an Excel text box?

Thank you

Gene

 

[Logit]

.
Place a textbox and a command button on your sheet.

Assign the command button to this macro :

Option Explicit


Sub gotext()
    Shell TextBox1.Text
End Sub

With the above, you will need to enter into the textbox "Outlook.exe"

 

[hiker8117]

I set up the Command Button and assigned the macro.

Option Explicit

Sub gotext()
Shell TextBox1.Text
End Sub

However not sure how to go about the entry "Outlook.exe".

When I insert a text box and right click it gives me the ability to add a hyperlink or assign a macro.

Not sure how the "Outlook.exe comes into play with the text box.

Appreciate your help

Thank you

Gene

<tbody> [TD="width: 64"]

<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]

</tbody>

[/TD]

</tbody>

 

[Logit]

.
Dont right click the text box. Type into the text box : Outlook.exe

Then click the button.

 

[hiker8117]

Ok..please be patient.

I have the command button assigned to the code.

I inserted a text box in the spreadsheet from the ribbon Insert Text and a drop down gives me a number of choices: Text Box, Header/Footer,Word Art etc etc.

I typed in the text box Outlook.exe which seems to more of a text label than a command.

I hit the command button and got an error: Compile error variable not defined. Am I using the right type of text box.

Thank you

Gene

 

[Logit]

.
Ok ... I am embarrassed, ashamed and you are going to be very frustrated with me.
If you can accept my apology, please do so.

I gave you the wrong code.

Here is the corrected macro :

Option Explicit


Sub gotext()
    Shell Sheets("Sheet1").TextBox1.Text
End Sub

You can download the sample workbook, that works !, from here : https://www.amazon.com/clouddrive/share/zvhdWyI8fu5yi0N8oze1Bx32B2cyVRpmXRdpJyPFcXk

Yes, I believe you most likely inserted the correct textbox but because of my stupid error, of course it wouldn't work.


From the DEVELOPER TAB / INSERT / ACTIVE X CONTROLS .. you would select TEXTBOX. Then of course you would select a COMMAND BUTTON from FORM CONTROLS, attaching that button to the macro
located in a Routine Module.

HTH

 

[hiker8117]

Apology accepted but I really appreciate your time and efforts.

I will give it a try.

Regards

Gene

.
Ok ... I am embarrassed, ashamed and you are going to be very frustrated with me.
If you can accept my apology, please do so.

I gave you the wrong code.

Here is the corrected macro :

Option Explicit


Sub gotext()
    Shell Sheets("Sheet1").TextBox1.Text
End Sub

You can download the sample workbook, that works !, from here : https://www.amazon.com/clouddrive/share/zvhdWyI8fu5yi0N8oze1Bx32B2cyVRpmXRdpJyPFcXk

Yes, I believe you most likely inserted the correct textbox but because of my stupid error, of course it wouldn't work.


From the DEVELOPER TAB / INSERT / ACTIVE X CONTROLS .. you would select TEXTBOX. Then of course you would select a COMMAND BUTTON from FORM CONTROLS, attaching that button to the macro
located in a Routine Module.

HTH

 

[Logit]

Let me know if it works for you.

 

[hiker8117]

Let me know if it works for you.

It worked perfectly..thanks again.

Regards

Gene

 

[Logit]

.
You are welcome.