Body in Email code please help

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,081
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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,109,315
Messages
5,527,957
Members
409,794
Latest member
ajithppajith

This Week's Hot Topics

Top