How to email to a email address inside a textbox

[Pookiemeister]

I have button on my form that I would like use to open outlook to send an email to the person inside the textbox which is labeled "Email", as a start. Thank you.

 

[JEC]

You're welcome!

 

[Pookiemeister]

@JEC

One more thing about your code above. The following shortened code does not work as expected. It always goes to the Case Else condition there needs to be an AND with Case Is like in the original code but Case does not allow an AND.

Select Case Time
    Case Is < "12:00:59": Salutation = "Good morning "
    Case Is < "16:59:59": Salutation = "Good afternoon "
    Case Is < "20:59:59": Salutation = "Good evening "
    Case Else: Salutation = "Dear "
 End Select

 

[JEC]

Here it works. You don't need an And.
Same result this way?

Select Case Time
    Case Is < TimeValue("12:00:59"): Salutation = "Good morning "
    Case Is < TimeValue("16:59:59"): Salutation = "Good afternoon "
    Case Is < TimeValue("20:59:59"): Salutation = "Good evening "
    Case Else: Salutation = "Dear "
 End Select

 

[welshgasman]

@JEC

One more thing about your code above. The following shortened code does not work as expected. It always goes to the Case Else condition there needs to be an AND with Case Is like in the original code but Case does not allow an AND.

Select Case Time
    Case Is < "12:00:59": Salutation = "Good morning "
    Case Is < "16:59:59": Salutation = "Good afternoon "
    Case Is < "20:59:59": Salutation = "Good evening "
    Case Else: Salutation = "Dear "
 End Select

Works for me also at 16:29 with Good afternoon ?