如何使用mailto超鏈接功能從Excel發送電子郵件？

在Excel中，可以使用mailto超鏈接功能從Excel創建電子郵件。由mailto超鏈接創建的電子郵件包括收件人的電子郵件地址，主題和正文。在本文中，我們將向您展示如何使用mailto超鏈接功能從Excel發送電子郵件。

使用超鏈接功能從Excel發送電子郵件
 使用超鏈接功能從Excel發送電子郵件
 使用Kutools for Excel根據創建的郵件列表通過Outlook輕鬆發送電子郵件

使用超鏈接功能從Excel發送電子郵件

在本節中，我將向您展示如何在Excel中直接創建mailto超鏈接。請執行以下操作。

1.首先，您需要在單元格B1，B2和B3中分別輸入收件人地址，電子郵件主題和電子郵件正文。查看截圖。

2.選擇您想要mailto超鏈接所在的空白單元格，例如單元格B4。

3.複製並粘貼超鏈接功能 = HYPERLINK（“ mailto：”＆B1＆“？subject =”＆B2＆“＆body =”＆B3，“鏈接文本”）進入所選單元格的編輯欄中，然後按 Enter 鍵。

備註：在公式中，B1，B2和B3包含收件人的地址，電子郵件主題和正文； “鏈接文本”是該超鏈接的顯示文本。您可以根據需要更改它們。

從現在開始，單擊mailto超鏈接時，將自動創建帶有指定收件人，主題和正文的Outlook電子郵件。看截圖：

使用超鏈接功能從Excel發送電子郵件

由於上述方法的局限性，在此我介紹一種在Excel中創建mailto超鏈接的其他方法。

1.選擇要創建mailto超鏈接的單元格。

2。點擊插入 > 超鏈接。看截圖：

3。在裡面 插入超鏈接 對話框，您需要：

1）。請點擊 電子郵件地址 在鏈接窗格

2）。在“收件人”中輸入收件人的電子郵件地址 E-mail地址 框;

3）。在裡面主旨框，輸入電子郵件主題，輸入電子郵件主題後，輸入＆body =電子郵件正文;

例如，如果電子郵件主題是“電子郵件的主題”，而電子郵件正文是“電子郵件的正文”，請輸入電子郵件的主題＆正文=電子郵件的正文到主旨框。

4）。點擊 OK 按鈕。看截圖：

然後創建mailto超鏈接。單擊它，將創建一個Outlook電子郵件，其中列出了所有指定收件人的地址，主題和正文。

使用Kutools for Excel根據創建的郵件列表通過Outlook輕鬆發送電子郵件

本節將推薦 發電子郵件 的效用 Kutools for Excel。使用此實用程序，您可以輕鬆地發送帶有在Excel中創建的指定郵件列表的電子郵件。請執行以下操作。

申請前 Kutools for Excel請 首先下載並安裝.

1.首先，您需要在Excel中創建所需的郵件列表。請點擊 Kutools Plus > 創建郵件列表。看截圖：

2。在裡面 創建郵件列表 對話框中，請同時檢查您需要在電子郵件中包含的字段 郵件列表列 或 附加文件 部分。指定放置創建的郵件列表的位置，然後單擊創建按鈕。看截圖：

3.現在，將創建一個示例郵件列表。請使用您所需的內容填寫相應的字段，如下圖所示：

4.選擇整個郵件列表，然後單擊 發電子郵件 功能區中的按鈕。看截圖：

5。在裡面 發電子郵件 對話框中，您可以看到所有字段都填充有相應的郵件列表內容，根據需要編寫郵件正文，然後選中 通過Outlook發送電子郵件 框，最後單擊發送按鈕發送電子郵件。看截圖：

6.之後， Kutools for Excel 彈出對話框，告訴您有關電子郵件發送的信息，請單擊 OK 按鈕，然後關閉“發送電子郵件”對話框。

現在，您可以轉到Outlook的“發送郵件”文件夾來檢查已發送的電子郵件。看截圖：

如果您想免費試用該工具（30天）， 請點擊下載，然後按照上述步驟進行操作。

使用Kutools for Excel，基於Excel中創建的郵件列表輕鬆通過Outlook發送電子郵件

如何通過Excel中的mailto函數自動將“抄送”或“密件抄送”字段發送給電子郵件？

最佳辦公效率工具

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

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

閱讀更多... 免費下載... 採購...

Office選項卡為Office帶來了選項卡式界面，使您的工作更加輕鬆

在Word，Excel，PowerPoint中啟用選項卡式編輯和閱讀，發布者，Access，Visio和Project。
在同一窗口的新選項卡中而不是在新窗口中打開並創建多個文檔。
每天將您的工作效率提高50％，並減少數百次鼠標單擊！

閱讀更多... 免費下載... 採購...

33 Comments
Login

Sort by Newest
- Best
- Popular
- Newest
- Oldest

You are guest

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.
jamievo · 1 years ago
Is it possible to have a hyperlink of the file path of the workbook itself generated in the body of the email?
- Reply
To post as a guest, your comment is unpublished.
Rach · 2 years ago
Hi, for the attachment, can it be any type of documents eg word, pdf? how much is your fee if I only want to send mass emails from excel spreadsheet?
- Reply
To post as a guest, your comment is unpublished.
Trial version user · 3 years ago
Hello, as per the auto-emailing component, is it possible to have a fixed Subject and a fixed Body? In other words I want to send emails without typing anything.
- Reply
- To post as a guest, your comment is unpublished.
  Chadd · 1 years ago
  
  I just figured out two work arounds for this trial version user
  method 1) is to choose a cell that's outside your data and enter the fixed text there. A1 is the cell I chose for my example. in the formula you just need $ in front of the cell letter and number so it always will go to that cell no matter where you copy the formula to. (shown below in the fixed subject)
  method 2) type the fixed info right in your formula with quotes example is the fixed body below
  
  example: =HYPERLINK("mailto:" & B1 & "?subject="& $A$1 & "&body="&"fixed body","AutoEmail")
  
  Reply
- To post as a guest, your comment is unpublished.
  crystal · 3 years ago
  
  Good Day,
  This function does not take into account right now yet. Thank you for sharing.
  
  Reply
To post as a guest, your comment is unpublished.
Gustavo · 3 years ago
The body I'm using is a formula =concatenate(b5,b6,b7,b8) and it gives my a #value error. Is there a work around to use formulas?
- Reply
- To post as a guest, your comment is unpublished.
  Chadd · 1 years ago
  
  yes I just figured out the work around for this Gustavo. example: =HYPERLINK("mailto:" & B1 & "?subject="& B2 & "&body=" & B5&" "&B6&" "&B7&" "&B8&", "Linking text")
  
  im having an issue with the linking text to display afterwards, but other than that it works perfectly.
  
  Reply
- To post as a guest, your comment is unpublished.
  crystal · 3 years ago
  
  Dear Gustavo,
  Sorry can't solve this problem.
  
  Reply
To post as a guest, your comment is unpublished.
EmDee · 3 years ago
I love this function!My only issue is that if B4 is formatted as a date, outlook does not see it as such. (example if 10-Dec-17 = 402368")I'd love to find a work around for this! My B4 has conditional formatting, which requires the formatting to stay as is.
- Reply
- To post as a guest, your comment is unpublished.
  EmDee · 3 years ago
  
  Correction: Cell B3 - Sorry (Body of email)
  
  Reply
  
  To post as a guest, your comment is unpublished.
  
  crystal · 3 years ago
  
  Sorry Mike,
  Can't solve this problem.
  
  Reply
To post as a guest, your comment is unpublished.
Mike · 3 years ago
I love this function! My only issue is that if B4 is formatted as a date, outlook does not see it as such. (example if 10-Dec-17 = 402368")

I'd love to find a work around for this! My B4 has conditional formatting, which requires the formatting to stay as is.
- Reply
To post as a guest, your comment is unpublished.
Rishi Raj · 3 years ago
Thanks a lot its very helpful feature u describe here apart from that can we create a shortcut of attachment.
- Reply
To post as a guest, your comment is unpublished.
setu · 3 years ago
how can i add another body in excel cell with your formula
- Reply
- To post as a guest, your comment is unpublished.
  crystal · 3 years ago
  
  Dear setu,
  
  If you need to add another body in cell with this formula, please add this body cell into the body section and separate these two bodies by a seperator as you need: =HYPERLINK("mailto:"&B1&"?subject="&B2&"&body="&B3 &" "&B4,"Linking text"). See screenshot:
  
  reply-comment-6.png
  
  Reply
  
  To post as a guest, your comment is unpublished.
  
  TIFFANI JONES · 3 years ago
  
  Hello,
  
  This was very helpful, I have one question, is there a way to create the body of the email such that B3 and B4 would be on their own separate line w/in the body of the email and not on one line? Make sense? I would like the feature to be such that it was like I pressed enter after B3 and B4 starts a new line.
  
  Reply
To post as a guest, your comment is unpublished.
Ian · 3 years ago
Is there a formula to send the current worksheet or book as an attachment to a recipient?
Regards
Ian
- Reply
- To post as a guest, your comment is unpublished.
  CHRIS · 3 years ago
  
  Ian, as far as I know there is no attachment option in 'mailto:' syntax. It supports only aditional 'cc', 'bcc', 'subject' and 'body' fields.
  
  Reply
  
  To post as a guest, your comment is unpublished.
  
  Vance · 3 years ago
  
  There is, it is the Attachment= but, unfortunately, like you I have not found a way to include the current spreadsheet using it. You can use a Macro, but it only seems to work with Outlook:
  Sub Email_Excel_Button()
  ActiveWorkbook.SendMail Recipients:="you@there.com", Subject:="Spreadsheet"
  End Sub
  
  Reply
To post as a guest, your comment is unpublished.
Chris · 3 years ago
I think there is some limitation in 'body=' string length that causes the '#ARG' error. Try to shorten the string.
- Reply
To post as a guest, your comment is unpublished.
Rutva · 3 years ago
When i try to add email body in cell, it gives me error. How can it be resolved ?
- Reply
To post as a guest, your comment is unpublished.
Rutva · 3 years ago
=HYPERLINK("mailto:" & B7 & "?subject="& B8 & "&body=" & B9 & "body=" & B10 & "body=" & B11 & "body=" & B12, "Linking text")

What if we want to add multiple lines in body ? I tried above formula but did not worked. Please help
- Reply
To post as a guest, your comment is unpublished.
Will · 3 years ago
Great post. However, it will not work when I write 2017-2018 Insurance Invoices in the subject. If I simply write Insurance Invoices it works. Is there a limitation or a workaround solution? Thanks.
- Reply
- To post as a guest, your comment is unpublished.
  Paul · 3 years ago
  
  Will, you are leading with numbers that you intend to use as text so just insert an apostrophe before the number. (ex: '2017-2018 Insurance Invoices.)
  
  Reply
To post as a guest, your comment is unpublished.
Riz · 3 years ago
Hi, how can i send a complete table to email body using hyperlink function in Excel 2013?
- Reply
To post as a guest, your comment is unpublished.
Riz · 3 years ago
Hi All, is it possible to send a complete table in the body of the email using this function?
- Reply
To post as a guest, your comment is unpublished.
RF · 3 years ago
Hi,

I am using excel 2013, I have set up the e-mail link within excel. However when i click send the e-mail box pops up and requires me to click send manually. Is there a simple way or steps that I have to take in order to just click on the hyperlink and excel will automatically send the e-mail? And perhaps provide a confirmation that will log itself somewhere into the excel worksheet (so we know it's worked)?
- Reply
To post as a guest, your comment is unpublished.
Mark W · 4 years ago
As above, Can you create an email with the workbook as an attachment?
- Reply
To post as a guest, your comment is unpublished.
Shez · 4 years ago
Hi, thanks in advance for the help.
Can you create an email with the workbook as an attachment?
basically create a mailto hyperlink that creates an email with the workbook as an attachment, from the same workbook.
- Reply
To post as a guest, your comment is unpublished.
ANAND KUMAR · 4 years ago
Thanks Alan ☺.........It did work.
- Reply
To post as a guest, your comment is unpublished.
Alan F. · 4 years ago
=HYPERLINK("mailto:"&B1&"?subject="&B2&"&body="&B3&"&cc="&B4&"& A5","Email To Someone")
where b4 is in the format someone@somewhere.com;someonelese@somewhereelse.com
- Reply
To post as a guest, your comment is unpublished.
Curtis · 4 years ago
This does not work, at least with Office 2016. The created link places the cell reference in the To filed of the email opened in Outlook rather than the email address. In the example used, the email will be addressed to B1 rather than the content of cell B1.
- Reply
To post as a guest, your comment is unpublished.
Anand Kumar · 4 years ago
How can we add CC and BCC column there. Please explain.
- Reply

登錄到您的帳戶

重設密碼