How can i attach active workbook to email- please see the macro

  • Thread starter Thread starter stric
  • Start date Start date
S

stric

This is the part of the macro that I created.

Sheets("Contract Expiration Report").Copy
Set MItem = OutlookApp.CreateItem(0)
With MItem
.To = EmailAddr
.Subject = RegionToGet
.Body = Msg
.Display
End With
ActiveWorkbook.Close Savechanges:=False

The whole macro filter out certain records, saves them in a sheet an
then is supposed to send the sheet to EmailAddr. The problem is tha
everything but the sheet goes. Can you tell me how to attach tha
sheet?
Or how can I attach newly created files in general
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

to many e-mails 2
Automated Email 2
Help needed with the following macro 1
Excel Macro to Copy Word Text into an Email 6
Run macro from active workbook whose name keeps changing 20
INPUT BOX in excel 2003 2
code to attach a macro to a newly created worksheet 2
Excel Macro user function used in several sheets in same workbook 1

Back
Top