Patriot2879
Well-known Member
- Joined
- Feb 1, 2018
- Messages
- 1,228
- Office Version
- 2010
- Platform
- Windows
Hi, please can you help i have the code below where i have a button and when i click on it it goes to email, but i want to add .Body into the code please can you advise how i add this into the code please?
Code:
Sub Button3_Click()
Link = "mailto:john.dowe@talk.com; john.dowe@talk.com?cc=john.dowe@talk.com; john.dowe@talk.com; john.dowe@talk.com; john.dowe@talk.com; john.dowe@talk.com&subject=Handover on day"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub
Last edited: