On clicking "Send Email" button in "Mail Outlook" sheet , it copies the "Email Data" sheet to body of Outlook with attachment if any added.
But the 4 pie charts in the end of the "Email Data" sheet is got getting pasted in email body .
Can anyone help me with this . Any help will be appreciated .
Also i want cell J7 in "Mail Outlook' sheet to show and take reference path(the directory in which it is present) instead of actual path .
Sheets attached
Best.xlsm
Bookmarks