What is the syntax to open a New Email window?

Dim sHLink As String
SHLink = “mailto:<recipient’s email address>?subject=<subject line here>&body=<body message here>
ActiveWorkbook.FollowHyperlink(SHLink)
‘example
Dim sHLink As String
sHLink = mailto:youremail@gmail.com?subject=Sample Subject Line&body=Hello
ActiveWorkbook.FollowHyperlink(SHLink)

image046

Advertisements