Email from VBA

[ss002d6252]

I have code which quite happily opens an email and sets the recipient and subject but it won't set the body .

Any one have ideas where I'm going wrong ?

    Dim emaddr As String
    Dim subj As String

    emaddr = "Council.Tax@Sunderland.gov.uk"
    subj = "Council Tax Enquiry"
    
   'compose default parts of the message
    hlink = "mailto:" & emaddr & "?"
    hlink = hlink & "subject=" & subj
    hlink = hlink & "&body =" & "This is a test"
    
    'open email
    ActiveWorkbook.FollowHyperlink hlink

 

[ss002d6252]

Solved

For future reference it was the gap between &body and the = sign that was the problem.