Excel Pivot Mail Merge

Hai There,

I'm using a code where I can able to send the pivot table in the body of email using mail merge. But I'm getting a lot of blank space between my pivot table and signature.

I had hidden all the rows by taking the referance of Grand total in the pivot but still i'm getting the blank space underneath.

excel attached for ready referance..


Thanks in advance...