执行发送给邮件收件人 [英] Execute Send To Mail Recipient

查看:96
本文介绍了执行发送给邮件收件人的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

以下打开资源管理器窗口并选择.zip文件夹:

The following opens an Explorer window and selects a .zip folder:

Dim FilePath As String

FilePath = CurrentProject.Path& " \ ORCAS Reports.zip"

Shell" Explorer.exe" &安培; Chr(34)& FilePath& Chr(34),vbNormalFocus

Dim FilePath As String
FilePath = CurrentProject.Path & "\ORCAS Reports.zip"
Shell "Explorer.exe " & Chr(34) & FilePath & Chr(34), vbNormalFocus

然后,用户可以右键单击Send To Mail Recipient并将其发送给任何他们想要的人。

The user can then right-click the Send To Mail Recipient and send it to whoever they want.

有没有人知道是否可以使用VBA脚本执行右键单击"发送到邮件收件人"命令?

Does anyone know if it is possible to execute the right-click Send To Mail Recipient command using VBA script?

推荐答案

我编写了代码来发送附件
这里
。您只需将文件路径传递给过程。
I wrote code to send attachments here. You can just pass the file path to the procedure.


这篇关于执行发送给邮件收件人的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆