Consulting

Results 1 to 2 of 2

Thread: Adding Range to Mail Body

  1. #1

    Adding Range to Mail Body with same format

    Hi Guys,
    I'm absolutely new to VBA and looked around for the attached code to get what i needed which does exactly what i need, it has a section to copy a range,but it doesn't keep format(it's a pivot table). I need help as to how to make it keep the format.

    --Had to attach it cause i'm a new member
    Attachment 26706Attachment 26707
    Attached Files Attached Files
    Last edited by MMaghawry; 05-20-2020 at 02:55 PM.

  2. #2
    Without the materials to test, it appears that you are converting the worksheet data to text (strPaste). Instead of doing that copy the Excel range to the clipboard and paste that into the message range (oRng)
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •