@jec


how can i display the result in a body of an email instead?
I'm trying below and it just says type mismatch

.body = "Hi" & vbNewLine & vbNewLine & sq