Hi, i have the code below for a button once clicked on opens an email with address etc, but i want to add ******> as well please can you advise how i do this? with like Hi All, then a break to start a new line then to enter my sentence? Private Sub CommandButton6_Click() Link = "mailto:NC@talktalk.com&subject=OPTIMISATION please book ASAP for MIDE" On Error GoTo NoCanDo ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True Exit Sub NoCanDo: MsgBox "Cannot open " & Link End Sub

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Body in Email code please help

Thread starter Patriot2879
Start date Sep 19, 2018
Tags

code commandbutton6_click email link nocando

Patriot2879

Well-known Member

Sep 19, 2018

Hi, i have the code below for a button once clicked on opens an email with address etc, but i want to add ******> as well please can you advise how i do this? with like Hi All, then a break to start a new line then to enter my sentence?

Code:

Private Sub CommandButton6_Click()
    Link = "mailto:NC@talktalk.com&subject=OPTIMISATION please book ASAP for MIDE"
    On Error GoTo NoCanDo
    ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True


    Exit Sub
NoCanDo:
    MsgBox "Cannot open " & Link
End Sub