如何使用VBA将Excel数据粘贴到Outlook图像中?

时间:2020-12-01 20:28:09

I have an Excel sheet with data in a1:q38 that I need to paste into the BODY of an outlook email. Any idea how to do this while not saving the image as a jpg or png?

我有一个Excel表格,里面有a1:q38,我需要把它粘贴到outlook邮件的正文中。你知道如何在不将图片保存为jpg或png的情况下做到这一点吗?

1 个解决方案

#1


1  

The Outlook object model provides three main ways for working with item bodies:

Outlook对象模型为处理项目主体提供了三种主要方式:

  1. Body.
  2. 的身体。
  3. HTMLBody.
  4. HTMLBody。
  5. The Word editor. The WordEditor property of the Inspector class returns an instance of the Word Document which represents the message body. So, you can use the Word object model do whatever you need with the message body.
  6. “编辑器”这个词。Inspector类的WordEditor属性返回表示消息体的Word文档的一个实例。因此,您可以使用object model这个词来处理消息体。

For example, you can use the Copy method of the Range class from the Excel object model and then use the Paste method of the Range class from the Word object model to paste the copied data in Excel.

例如,您可以使用来自Excel对象模型的Range类的Copy方法,然后使用Word对象模型的Range类的Paste方法将复制的数据粘贴到Excel中。

See Chapter 17: Working with Item Bodies for more information.

参见第17章:与项目机构合作获取更多信息。

#1


1  

The Outlook object model provides three main ways for working with item bodies:

Outlook对象模型为处理项目主体提供了三种主要方式:

  1. Body.
  2. 的身体。
  3. HTMLBody.
  4. HTMLBody。
  5. The Word editor. The WordEditor property of the Inspector class returns an instance of the Word Document which represents the message body. So, you can use the Word object model do whatever you need with the message body.
  6. “编辑器”这个词。Inspector类的WordEditor属性返回表示消息体的Word文档的一个实例。因此,您可以使用object model这个词来处理消息体。

For example, you can use the Copy method of the Range class from the Excel object model and then use the Paste method of the Range class from the Word object model to paste the copied data in Excel.

例如,您可以使用来自Excel对象模型的Range类的Copy方法,然后使用Word对象模型的Range类的Paste方法将复制的数据粘贴到Excel中。

See Chapter 17: Working with Item Bodies for more information.

参见第17章:与项目机构合作获取更多信息。