Want to quickly attach your Excel workbook into an email message with a single click? You can do this with Excel Macros!

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Attach your current workbook into an Outlook email message

Copy Source Code:


Sub AttachWorkbookIntoEmailMessage()

Dim OutlookApp As Object
Dim OutlookMail As Object
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)

'Let us create the email message and display it
'Make sure to change the parameters below
With OutlookMail
.To = "support@myexcelonline.com"
.Subject = "Have a look at this workbook"
.Body = "Hey John, Could you help out on this?"
.Attachments.Add ActiveWorkbook.FullName
.Display
End With

Set OutlookMail = Nothing
Set OutlookApp = Nothing

End Sub

Final Result: 

Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline

Exercise Workbook:

Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK


STEP 1: Go to Developer > Code > Visual Basic

Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline

 

STEP 2: Paste in your code and Select Save.

You can change the following fields – To, Subject and Body depending on your preferences. These are marked in yellow.

Close the window afterwards.

Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline

 

STEP 3: Let us test it out!

Go to Developer > Code > Macros

Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline

 

Make sure your macro is selected. Click Run.

Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline

 

With just one click, your Excel Workbook is now attached to the email message!Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline

 

How to Attach Current Workbook into an Email Message Using Macros In Excel

 

HELPFUL RESOURCE:

101 Macros Book

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Attach Current Workbook into an Email Message Using Macros In Excel | MyExcelOnline