Copy data to Outlook email as Image or table

[E5254730]

Hello Experts,

I'm using below source of code to filter the data as per Project Number.

In attached, when we manually enter the Project Number in B1 cell in Sheet 2, the data gets updated for that respective project from Cell A6 to last cell in E column. Data is updated from Raw Data tab.

I'm good with this, but now I have a requirement to copy the output data from cell A5 to last active cell in column E.

For e.g. when we enter Project Number as 4 in B1 cell, the data gets updated for Project No. 4 i.e. from A6 to E16

Similary when we enter Project No. as 2, the data gets updated through A6 to E8. (it will be good, if the data is in excel format and not an image)

And the body of the email should be as below :

Hello John,

Please refer to below table on Project updates:

Capture12.JPG

Below are the key highlights:

And more text

And more text

(Signature of the Person sending the email)

[maniacb]

I hope I have been able to meet your requirements. Let us know if you have questions.

Please Login or Register  to view this content.