That worked correct after incorporating with all other codes.
what code would be required if i want to create a pivot and then paste the pivots on an email body. Is this possible through a code?