Screen clipping tool outlook 2016 in main outlook

#Screen clipping tool outlook 2016 in main outlook how to#
#Screen clipping tool outlook 2016 in main outlook install#
#Screen clipping tool outlook 2016 in main outlook software#

#Screen clipping tool outlook 2016 in main outlook software#

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including recover mdf and outlook repair software products. Afterwards, you need to invest in a robust third party repair utility, such as DataNumen Outlook Repair, which can repair PST file without breaking a sweat. In such a situation, you have to firstly run antivirus software to kill the viruses. If you accidentally download any virus-infected attachments, your Outlook file is very likely to be attacked and thereby become compromised.

Lastly, the screenshot of the Excel worksheet will be inserted into the mail body.

In the small dialog box, click вЂњAllowвЂќ button.

Set objMail = objOutlookApp.CreateItem(olMailItem) Set objOutlookApp = CreateObject('Outlook.Application') Outlook 2016 uses two types of data files, including the Offline Outlook File (.ost) and the Outlook Data File (.pst), depending on the type of account you configured to store offline copies of. ObjUsedRange.CopyPicture xlScreen, xlPicture 'Change 'Sheets(1)' to the specific worksheet number Sub ExportInsert_ScreenshotOfSheet_Mail()

After that, copy the following VBA code into a project or module.

#Screen clipping tool outlook 2016 in main outlook how to#

Next, add the reference to вЂњMS Outlook Object LibraryвЂќ and вЂњMS Word Object LibraryвЂќ according to вЂњ How to Add an Object Library Reference in VBAвЂњ.

Which view is the default for contacts in Outlook 2016 (76).

Which ribbon tab is not a default in Outlook 2016s main interface (76) Review.

Then, press вЂњAlt + F11вЂќ to trigger Excel VBA editor. A Task can be created in Outlook 2016 by clicking on the Tasks navigation item, or by.

At the very outset, open the Excel file.

Method 2: Copy the Screenshot of Excel Worksheet with VBA

Now, you can crop the screenshot at will.

At once, the screenshot of the Excel worksheet will be inserted.

In the вЂњAvailable WindowsвЂќ list, select the screenshot of the Excel worksheet.

Subsequently, click вЂњScreenshotвЂќ button.

Next, in the Message window, switch to вЂњInsertвЂќ tab.

A tiny dialog box shows you all the current windows open on your desktop so you can choose the one you want to insert.

Then, launch Outlook and create a new email. Begin by creating a new e-mail, and then click in the body of the message.

First off, open the Excel worksheet that you want to insert into email.

Method 1: Insert Screenshot of Excel Window And the second one is using a bit of scripting, as shown in the Method 2. The first one is by the inbuilt feature вЂ“ вЂњInsertвЂќ > вЂњScreenshotвЂќ, which is elaborately introduced in the following Method 1.

#Screen clipping tool outlook 2016 in main outlook install#

And the screenshot can be viewed even if the recipients donвЂ™t install MS Excel on their computers. Only in the screenshot, the cell values canвЂ™t be changed. Many users would like to export a screenshot of a specific Excel worksheet and then insert the screenshot into the message body of an Outlook email. Thus, this article will show 2 methods to get it.

At times, instead of copying the Excel worksheet into an emailвЂ™s body, you may want to insert the screenshot of the worksheet.