vba 如何将表格从 Excel 工作表复制粘贴到 Outlook 邮件
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/44802557/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to copy paste a table from Excel sheet to outlook mail
提问by Sai
I have a dynamic table in sheet2 of my Excel sheet. How to copy this entire table from sheet2 to outlook mail body using Outlook VBA.
我的 Excel 工作表的 sheet2 中有一个动态表格。如何使用 Outlook VBA 将整个表格从 sheet2 复制到 Outlook 邮件正文。
回答by sathya
The below steps you have to follow,
您必须遵循以下步骤,
Copy the tables into Microsoft word application
Now Copy the tables from Microsoft word application
Now Past the copied tables from Microsoft word application to your Email
This will work perfectly, let me know via comments if you are still facing the issue.
这将完美运行,如果您仍然面临问题,请通过评论告诉我。
回答by Shums
- Select First Cell of your table, means first header cell
- Press Ctrl+A
- Press Ctrl+C
- Switch to Outlook
- Place the Cursor in your Email Body where you want table
- Press Ctrl+V
- 选择表格的第一个单元格,表示第一个标题单元格
- 按 Ctrl+A
- 按 Ctrl+C
- 切换到 Outlook
- 将光标放在您想要表格的电子邮件正文中
- 按 Ctrl+V
回答by Shahnawaz
(1) Ctrl+A in your excel then (2) Ctrl+C and (3) Ctrl+V in outlook
(1) excel 中的 Ctrl+A 然后 (2) Ctrl+C 和 (3) Ctrl+V 在 Outlook 中