How to insert Outlook signature when sending email in Excel?

Supposing you want to send an email directly in Excel, how can you add the default Outlook signature in the email? This article provides two methods to help you adding Outlook signature when sending email in Excel.

Insert signature into Outlook email when sending by Excel VBA
Easily insert Outlook signature when sending email in Excel with an amazing tool
More tutorials for mailing in Excel...

Insert signature into Outlook email when sending by Excel VBA

For example, there is a list of email addresses in a worksheet, to send emails to all these addresses in Excel and add the default Outlook signature in the emails. Please apply the below VBA code to achieve it.

1. Open the worksheet contains the email address list you want to email to, and then press the Alt + F11 keys.

2. In the opening Microsoft Visual Basic for Applications window, click Insert > Module, and then copy the below VBA 2 into the Module code window.

3. Now you need to replace the .Body line in VBA 2 with the code in VBA 1. After that, move the line .Display under the line With xMailOut.

VBA 1: Template of sending emails with Outlook default signature in Excel

.HTMLBody = "This is a test email sending in Excel" & "<br>" & .HTMLBody

VBA 2: Send email to email addresses specified in cells in Excel

Sub SendEmailToAddressInCells()
    Dim xRg As Range
    Dim xRgEach As Range
    Dim xRgVal As String
    Dim xAddress As String
    Dim xOutApp As Outlook.Application
    Dim xMailOut As Outlook.MailItem
    On Error Resume Next
    xAddress = ActiveWindow.RangeSelection.Address
    Set xRg = Application.InputBox("Please select email address range", "KuTools For Excel", xAddress, , , , , 8)
    If xRg Is Nothing Then Exit Sub
    Application.ScreenUpdating = False
    Set xOutApp = CreateObject("Outlook.Application")
    Set xRg = xRg.SpecialCells(xlCellTypeConstants, xlTextValues)
    For Each xRgEach In xRg
        xRgVal = xRgEach.Value
        If xRgVal Like "?*@?*.?*" Then
            Set xMailOut = xOutApp.CreateItem(olMailItem)
            With xMailOut
                .To = xRgVal
                .Subject = "Test"
                .Body = "Dear " _
                      & vbNewLine & vbNewLine & _
                        "This is a test email " & _
                        "sending in Excel"
                .Display
                '.Send
            End With
        End If
    Next
    Set xMailOut = Nothing
    Set xOutApp = Nothing
    Application.ScreenUpdating = True
End Sub

The following screenshot can help you easily find the differences after changing the VBA code.

4. Press the F5 key to run the code. Then a Kutools for Excel select box pops up, please select the email addresses you will sent emails to, and then click OK.

Then emails are created. You can see Outlook default signature is added at the end of the email body.

Tips:

• 1. You can change the email body in VBA code 1 based on your needs.
• 2. After running the code, if an error dialog box pops up warning that the User-defined type not defined, please close this dialog, and then go to click Tools > References in the Microsoft Visual Basic for Applications window. In the opening References – VBAProject window, check the Microsoft Outlook Object Library box and click OK. And then run the code again.
  

Easily insert Outlook signature when sending email in Excel with an amazing tool

If you are a newbie in VBA, here highly recommend the Send Emails utility of Kutools for Excel for you. With this feature, you can easily send emails based on certain fields in Excel and add Outlook signature to them. Please do as follows.

Firstly, you need to create a mailing list with different fields you will send emails based on.

You can manually create a mailing list as you need or apply the Create Mailing List feature to quickly get it done.

1. Click Kutools Plus > Create Mailing List.

2. In the Create Mailing List dialog box, specify the fields you need, choose where to output the list, and then click the OK button.

3. Now a mailing list sample is created. As it is a sample list, you need to change the fields to certain needed content. (multiple rows are allowed)

4. After that, select the whole list (include headers), click Kutools Plus > Send Emails.

5. In the Send Emails dialog box:

• 5.1) Items in the selected mailing list are placed in corresponding fields automatically;
• 5.2) Finish the email body;
• 5.3) Check both the Send email via Outlook and Use Outlook’s signature settings boxes;
• 5.4) Click the Send button. See screenshot:

Now emails are sent. And the default Outlook signature is added at the end of the email body.

Related articles:

Best Office Productivity Tools

	Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
	Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
	Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
	Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
	Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
	Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Read More... Free Download...

---

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Read More... Free Download...