Pinterest Pixel

Attach Current Workbook into an Email Message Using Macros In Excel

Want to quickly attach your Excel workbook into an email message with a single click? You can... read more

Download Excel Workbook
Bryan
Posted on

Overview

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 = "[email protected]"
.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

Exercise Workbook:

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

Download excel workbookAttach-Current-Workbook-into-an-Email-Message.xlsm


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.

See also  Insert Multiple Worksheets Using Macros In Excel

Close the window afterwards.

Attach Current Workbook into an Email Message Using Macros In Excel

 

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

 

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

 

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

 

101 Macros Book

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!