如何應用按鈕發送帶有當前Word文件的電子郵件？

如果您需要通過Outlook從Word文檔發送電子郵件，並附加當前的Word文件，則可以創建命令按鈕，然後通過單擊此按鈕發送消息而無需打開Outlook。本文，我將介紹如何快速，輕鬆地處理它。

應用按鈕以發送帶有當前Word文件的電子郵件

應用按鈕以發送帶有當前Word文件的電子郵件

請執行以下步驟來解決Word文件中的這項工作：

1。首先，您應該創建一個命令按鈕，請單擊 開發者 > 舊版工具 > 命令按鈕（ActiveX控件），請參見屏幕截圖：

2。選擇按鈕，然後單擊 氟化鈉性能 在 開發者 標籤，在 氟化鈉性能 窗格中，將所需的標題文本輸入到標題字段，請參見屏幕截圖：

3。然後，關閉 氟化鈉性能 窗格，現在，右鍵單擊按鈕，然後選擇 查看代碼，請參見屏幕截圖：

4。然後，在顯示的 Microsoft Visual Basic for Applications 窗口，將以下代碼複製並粘貼到原始腳本之間，請參見屏幕截圖：

Dim xOutlookObj As Object
    Dim xEmail As Object
    Dim xDoc As Document
    Application.ScreenUpdating = False
    Set xOutlookObj = CreateObject("Outlook.Application")
    Set xEmail = xOutlookObj.CreateItem(olMailItem)
    Set xDoc = ActiveDocument
    xDoc.Save
    With xEmail
        .Subject = "Fax-data"
        .Body = "This is a test email."
        .To = ""
        .Importance = olImportanceNormal
        .Attachments.Add xDoc.FullName
        .Display
    End With
    Set xDoc = Nothing
    Set xEmail = Nothing
    Set xOutlookObj = Nothing
    Application.ScreenUpdating = True

備註：在上面的代碼中，您應該根據需要更改主題，正文或發送的地址。

5。然後，保存並關閉此代碼，單擊 設計模式 關閉設計模式。現在，單擊創建的命令按鈕時，將創建一封電子郵件，其中包含當前的Word文檔，請參見屏幕截圖：

6。最後，您只需要單擊送出按鈕發送此消息。

最佳辦公生產力工具

Kutools for Word - 透過 Over 提升您的文字體驗 100 顯著特點！

🤖 Kutools 人工智慧助手：用人工智慧改變你的寫作 - 生成內容 / 重寫文字 / 總結文件 / 查詢資料 基於文檔，全部在Word中

📘 文件掌握: 分頁 / 合併文件 / 以各種格式匯出選擇（PDF/TXT/DOC/HTML...） / 批次轉換為PDF / 將頁面匯出為圖像 / 一次列印多個文件...

✏ 內容編輯: 批量查找和替換 跨多個文件 / 調整所有圖片的大小 / 轉置表行和列 / 將表格轉換為文字...

🧹 輕鬆清潔: 移開 多餘的空間 / 分節符 / 所有標題 / 文本框 / 超鏈接 / 如需更多拆卸工具，請前往我們的 刪除組...

➕ 創意插入：插入 千位分隔符 / 複選框 / 單選按鈕 / QR Code / 條碼 / 對角線表 / 公式標題 / 圖片說明 / 表格標題 / 多張圖片 / 發現更多 插入組...

🔍 精準選擇：精確定位特定頁面 / 表 / 形狀 / 標題段落 / 增強導航功能更多 選擇功能...

⭐ 星級增強: 快速導航至任何位置 / 自動插入重複文字 / 在文檔視窗之間無縫切換 / 11 轉換工具...

???? 想嘗試這些功能嗎？ Kutools for Word 提供了 60天免費試用，沒有任何限制！ 🚀

免費下載閱讀更多立即購買

Comments (30)

No ratings yet. Be the first to rate!

Stephane Parzysz

about 3 months ago

#44552

This comment was minimized by the moderator on the site

Hey, in my case the button works well but not in a Word document saved with a password. Can somebody help me to fix this?
Best regards

about 1 year ago

#42138

This comment was minimized by the moderator on the site

Hi Skyyang,

I found this works when a user has MS Word but it seems emails like @hotmail; @gmail; and @live email addresses those users have issues where the button doesn't work?
It seems it also doesnt work on smart phones either if the user relies on using these as opposed to a computer.
Lastly I've had a response from another user using Windows 11 where the button doesn't work at all.

What have you experienced with the above examples please?

Thanks,

Mike

Report

about 1 year ago

#41641

This comment was minimized by the moderator on the site

Hi,
Please see the document attached below.
I need to update it for the 2023 renewals use and when merging the button seems to become disabled as several members told me it doesnt work.

Thanks,

Mike

View Attachments (1 / 5)

Report

skyyang

about 1 year ago

#41738

This comment was minimized by the moderator on the site

Hello, Mike,
I have tested your file in my computor, it wors well. I am using Office 2019. Please see the below demo:

https://www.extendoffice.com/images/stories/comments/comment-skyyang/send-doeument.gif

Report

about 1 year ago

#41477

This comment was minimized by the moderator on the site

I have found the button works to open an email but when using mailmerge the VBA button becomes inactive for some reason?
How can I ensure when mailmerging is used the button will work for user to complete the form and then activate the button please?

Report

skyyang

about 1 year ago

#41566

This comment was minimized by the moderator on the site

Hello, Mike,
When I use mailmerge feature, the button is in active.
Could you explain your problem more detailed?
Or you can upload your file here, so that we can check where the problem is.
Thank you!

Report

skyyang

about 1 year ago

#41710

This comment was minimized by the moderator on the site

Hi Skyyang,

Please see the post I put in below which has the copy attached.

Report

hpeyeease

about 1 year ago

#39310

This comment was minimized by the moderator on the site

Hello folks,

I want to apply a button where I click and send the document as email, not as an attachement, to one Email-Adress. So that the document is the text of the email. Just like the effekt of the button "send to recipient" on the ribbon.

Can someone give me the right code for that?

Thank you.

skyyang hpeyeease

about 1 year ago

#39356

This comment was minimized by the moderator on the site

Hello,
May be the code can't help to send the current word document as the email body, if to do, the picture and file formatting within the document will be lost.
If you want to send the current document as email body, the Mail Merge can do you a favor.
Do you need the Mail Merge for sending email?
If you need, please comment here.
Thank you!

Report

hpeyeease skyyang

about 1 year ago

#39369

This comment was minimized by the moderator on the site

Hello,

thank you for your help!

I would try it with your suggestion. Could u give me the code for mail merge?

Thanks!

skyyang hpeyeease

about 1 year ago

#39500

This comment was minimized by the moderator on the site

Hello,
To send current word document as mail body, you can add the Send to Mail Recipient command to your QAT, please do as this:
1. Open your word file that you want to send, and then click File > Options.
2. On the left pane, select Quick Access Toolbar.
3. Select Commands Not in the Ribbon from the Choose commands from.
4. Choose and select Send to Mail Recipient and click the button Add > >.
5. Click OK to close the dialog.

https://www.extendoffice.com/images/stories/comments/comment-skyyang/doc-send-file-1.png

Now, this Send to Mail Recipient command will show up in the Quick Access Toolbar at the top of your Word window. Then, you can insert the relative information into the message header. After finishing the information, please click Send a copy, the message with current word document as body will be sent at once.

https://www.extendoffice.com/images/stories/comments/comment-skyyang/doc-send-file-3.png

Please try this, hope it can help you!

Report

hpeyeease skyyang

about 1 year ago

#39368

This comment was minimized by the moderator on the site

Hello,

thank you for your help!

I would try it with your suggestion. So yes, I need the Mail Merge for sending E-Mail.

MandyZhou

about 1 year ago

#38673

This comment was minimized by the moderator on the site

Hello Heather,

You can add Bcc to this code. For example, you can add .Bcc = "" just below .To = "". So the code becomes:

Dim xOutlookObj As Object
Dim xEmail As Object
Dim xDoc As Document
Application.ScreenUpdating = False
Set xOutlookObj = CreateObject("Outlook.Application")
Set xEmail = xOutlookObj.CreateItem(olMailItem)
Set xDoc = ActiveDocument
xDoc.Save
With xEmail
.Subject = "Fax-data"
.Body = "This is a test email."
.To = ""
.Bcc = ""
.Importance = olImportanceNormal
.Attachments.Add xDoc.FullName
.Display
End With
Set xDoc = Nothing
Set xEmail = Nothing
Set xOutlookObj = Nothing
Application.ScreenUpdating = True

Please see the attached picture. Have a nice day.
Sincerely,
Mandy

https://www.extendoffice.com/images/stories/comments/comment-zmt/Add_Bcc_to_code.png

Report

Heather

about 1 year ago

#38547

This comment was minimized by the moderator on the site

Can you add Bcc to this code? I have tried adding Bcc and receive a compile error for expected expression.

Richard Bird

about 2 years ago

#36757

This comment was minimized by the moderator on the site

I have create the document but my issue now is that if I send this form to say 4 people to complete, when they open it up from the email attachment it opens in read only mode and when they click submit it asks them to save as before it will allow the code to open an email addressed to me. Is there a way around this other than giving them the location of the file?

Chelo

about 3 years ago

#34794

This comment was minimized by the moderator on the site

Hi Extend office,
Can we set a different email not linked to Outlook? Like direct email to GoDaddy account?

Shelby Chelo

about 2 years ago

#34795

This comment was minimized by the moderator on the site

I am trying to find out the same information. I use gmail and I need to create a form to send out to varies different email address that can automatically submit back to my gmail account.

Jacques

about 3 years ago

#34491

This comment was minimized by the moderator on the site

Does this also work for Lotus Notes?
What must I change in "xOutlookObj"?

There are no comments posted here yet

Please leave your comments in English

Posting as Guest

Name (Required)

Email (Required)

Rate this post:

Reset

0 Characters

更新日誌

功能教程

得到幫助？