Patriot2879
Well-known Member
- Joined
- Feb 1, 2018
- Messages
- 1,227
- Office Version
- 2010
- Platform
- Windows
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