提示:其他語言是Google翻譯的。 你可以訪問 English 版本。
登入
x
or
x
x
註冊
x

or

如何從Excel中通過Outlook發送當前工作簿?

也許,您總是在Excel工作簿中創建和修改報告,完成後,您需要盡快將當前保存的報告發送給部門經理。 如何在不從Excel打開Outlook的情況下快速將當前整個工作簿發送給特定人員?

使用保存並發送命令從Excel中通過Outlook發送當前工作簿

使用VBA代碼通過Outlook發送當前工作簿作為附件

Office選項卡在Office中啟用選項卡式編輯和瀏覽,使您的工作更輕鬆......
Kutools for Excel解決了您的大多數問題,並使您的生產率提高了80%
  • 重用任何東西: 將最常用或最複雜的公式,圖表和其他任何內容添加到您的收藏夾中,並在將來快速重複使用它們。
  • 超過20文本功能: 從文本字符串中提取數字; 提取或刪除部分文字; 將數字和貨幣轉換為英文單詞。
  • 合併工具:將多個工作簿和工作表合二為一; 合併多個單元格/行/列,而不會丟失數據; 合併重複的行和總和。
  • 拆分工具:根據價值將數據分割成多個工作表; 一本工作簿可轉換為多個Excel,PDF或CSV文件; 一列到多列。
  • 粘貼跳過 隱藏/過濾行; 數和總和 按背景顏色; 將個性化電子郵件批量發送給多個收件人。
  • 超級過濾器: 創建高級過濾方案並應用於任何工作表; 分類 按週,日,頻率等; 過濾 通過大膽,公式,評論......
  • 超過300強大的功能; 與Office 2007-2019和365一起使用; 支持所有語言; 在您的企業或組織中輕鬆部署。

箭頭藍色右泡 使用保存並發送命令從Excel中通過Outlook發送當前工作簿


有了這個 保存並發送 命令在Excel中,您可以通過Outlook快速發送整個工作簿作為附件,如PDF文件,XPS文件或Internet Fax。 你可以這樣做:

1。 打開您想要發送的工作簿。

2。 點擊 文件 > 保存並發送 > 使用電子郵件發送 在Excel 2010中,查看截圖:

DOC-發送-workbook1

提示:如果您使用Excel 2007,請點擊 辦公室按鈕 > 發送,看截圖:

DOC-發送-workbook4

在Excel 2013中,請點擊 文件 > 分享到 > 電子郵件,看截圖:

DOC-發送-workbook5

3。 然後從中選擇一種您想要發送Excel的格式 使用電子郵件發送 部分,在這種情況下,我點擊 作為附件發送 圖標按鈕,看截圖:

DOC-發送-workbook2

4。 並出現一個Outlook編輯窗口,輸入收件人名稱 - Cc 文本框,並在中輸入一個主題 主旨 框中,您還可以在簡介框中輸入一些消息,請參閱截圖:

DOC-發送-workbook3

筆記:

1。 只有當您使用Outlook作為您的郵件程序時,此方法才有效。

2。 發送工作簿後,您可以轉至Outlook以檢查電子郵件是否已成功發送。


箭頭藍色右泡 使用VBA代碼通過Outlook發送當前工作簿作為附件

在這裡,您還可以使用以下VBA代碼作為Excel附件發送當前工作簿,請按照以下步驟操作:

1. 打開您想要發送的工作簿。

2。 按住 ALT + F11 鍵,然後打開 Microsoft Visual Basic for Applications窗口.

3。 點擊 插入 > 模塊,並將以下代碼粘貼到 模塊窗口.

VBA代碼:從Excel發送當前工作簿作為附件

Sub SendWorkBook()
'Update 20131209
Dim OutlookApp As Object
Dim OutlookMail As Object
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
On Error Resume Next
With OutlookMail
    .To = "skyyang@extendoffice.com"
    .CC = ""
    .BCC = ""
    .Subject = "kte feature"
    .Body = "Hello, please check and read this document, thank you."
    .Attachments.Add Application.ActiveWorkbook.FullName
    .Send
End With
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub

備註:在上面的代碼中,您可以根據自己的需要更改以下信息。

  • .to =“skyyang@extendoffice.com”
  • .CC =“”
  • .BCC =“”
  • .Subject =“kte功能”
  • .Body =“你好,請檢查並閱讀本文件,謝謝。”

4。 然後點擊 F5 鍵運行此代碼,並彈出一個提示框,單擊 ,並且此工作簿已發送出去。

DOC-發送-workbook6

筆記:

1。 此代碼僅在使用Outlook作為郵件程序時可用。

2。 發送工作簿後,您可以轉到您的Outlook以確保電子郵件已成功發送。


相關文章:

如何僅通過Excel中的Outlook發送工作表?

如何發送/電子郵件範圍的細胞通過展望從Excel?


Kutools for Excel解決了您的大多數問題,並使您的生產率提高了80%

  • 重用: 快速插入 複雜的公式,圖表 以及你以前用過的任何東西; 加密單元格 密碼; 創建郵件列表 並發送電子郵件...
  • 超級方程式酒吧 (輕鬆編輯多行文字和公式); 閱讀佈局 (輕鬆讀取和編輯大量單元格); 粘貼到過濾範圍...
  • 合併單元格/行/列 不丟失數據; 分裂細胞含量; 組合重複的行/列...防止重複的細胞; 比較範圍...
  • 選擇複製或唯一 行; 選擇空行 (所有細胞都是空的); 超級查找和模糊查找 在許多工作簿中; 隨機選擇......
  • 精確複製 多個單元格而不更改公式參考; 自動創建參考 多張表; 插入項目符號,複選框等等......
  • 提取文本,添加文本,按位置刪除, 刪除空間; 創建和打印分頁小計; 在單元格內容和註釋之間轉換...
  • 超級過濾器 (將過濾方案保存並應用到其他工作表); 高級排序 按月/週/日,頻率等; 特殊過濾器 用粗體,斜體......
  • 結合工作簿和工作表; 根據鍵列合併表; 將數據拆分為多個表格; 批量轉換xls,xlsx和PDF...
  • 超過300強大的功能。 支持Office / Excel 2007-2019和365。 支持所有語言。 在您的企業或組織中輕鬆部署。 全功能30天免費試用。
kte tab 201905

Office選項卡為Office提供選項卡式界面,使您的工作更輕鬆

  • 在Word,Excel,PowerPoint中啟用選項卡式編輯和閱讀,Publisher,Access,Visio和Project。
  • 在同一窗口的新選項卡中打開並創建多個文檔,而不是在新窗口中。
  • 通過50%提高您的工作效率,每天為您減少數百次鼠標點擊!
官方底部
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    sixto · 1 years ago
    this is attaching the file but the file does not show any changes that were made. it is attaching the last saved version
  • To post as a guest, your comment is unpublished.
    Pankaj · 2 years ago
    Thanks for sharing Information but i want in workbook a particular One sheet Only as a new sheet
  • To post as a guest, your comment is unpublished.
    Chris · 2 years ago
    Is there any way for the formula to copy certain cells and add that info to the body of the email?
  • To post as a guest, your comment is unpublished.
    T. Marshall · 2 years ago
    Did I miss the part in method 2 that tells you how to reuse the module? There's no button or other method to recall it upon next use?
  • To post as a guest, your comment is unpublished.
    David D · 3 years ago
    Does it actually save the file?
  • To post as a guest, your comment is unpublished.
    joe doe · 3 years ago
    Is there a way to configure it to send to a gmail account?
  • To post as a guest, your comment is unpublished.
    Dwarakesh · 3 years ago
    Hi everything is working great but i require two things first is i want attach the file i am currently working on automatically next is i want to send to multiple users

    thanks in advance
    • To post as a guest, your comment is unpublished.
      Roochops · 6 days ago
      use ; between users as below

      .To = "skyyang@extendoffice.com;bob@gmail.com"
  • To post as a guest, your comment is unpublished.
    Ottie · 4 years ago
    I have a "submit form" button on my worksheet and a macro enabled that will send it. Yet it comes through as a blank form. Can someone help me on how to get the data entered on the form to come through on the attachment?
    • To post as a guest, your comment is unpublished.
      Siggi B · 4 years ago
      Ottie, does your code save the workbook before trying to send? Any changes you have made since opening will only have been applied to a temp file (in case you were to close the WB and choose 'No' to the Save? ). So it may be sending the 'virgin' file.

      You could SaveAs the WB with the completed form as another file (ie FileToGo1), instruct Excel to attach FileToGo1 to the email, then delete FileToGo1 from the system, so that the next instance wont complain about overwriting an existing file. Or you could perform the SaveAs with a forced overwrite.

      This could also allow you to SaveAs a non-macro WB, so that the recipient doesn't get any alerts or disabling of the WB because their system is paranoid about possible macro security breaches.

      Cheers,

      Siggi.
  • To post as a guest, your comment is unpublished.
    nishant goel · 5 years ago
    Hi,


    This VB coding suits my requirement but there is a peoblem in this. i do not want to send my mail directly.i wnat to check my mail before sending as i have to send this mail to different persons. so i want to edit the name of the receiver.Please Help & revert.

    regards,
    Nishant Goel
    • To post as a guest, your comment is unpublished.
      Siggi B · 5 years ago
      to review the email before / instead of sending it, replace the ".send" with ".display" at the end of the With block.

      Cheers,
      Siggi.