Macro to email -Part of body of email not displaying in body

[Howardc1001]

I have the following macro to attach 2 sheets and to create an email to be sent

The section below is not appearing in the body of the email

Please Login or Register  to view this content.

It would be appreciated if someone could kindly assist me in resolving this

Please Login or Register  to view this content.

[ORoos]

Try to ad .Value at the end of the reference.
My suggestion would be to declare the 2 variables first and then in the email body insert the variables.

Dim eAvailable as Long
Dim eTotal as Long
....
eAvailable = Sheets("Summary").Range("Q18").Value
eTotal = Sheets("Summary").Range("P18").value
...

[Howardc1001]

thanks your help & input