SendMail File linked error

L

Linc

I am using the following macro

!-- Start of Macro

Sub CopySave()
'
' Copy Save Print & Mail Macro
' Macro 11/3/2003 by LNC
'
Sheets("Incident_Report").Select
Sheets("Incident_Report").Copy
' ActiveSheet.Protect DrawingObjects:=True, Contents:=True
Scenarios:=True
Sheets("Incident_Report").Name = "Incident_Report_" & Cells(1, 12)
ActiveWorkbook.SaveAs "D:\DatatecReviews\Incidents\Incident "
Cells(1, 12)
' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Set wb = ActiveWorkbook
With wb
.SendMail "(e-mail address removed)", _
"Incident Report"
.Close False
End With
Application.ScreenUpdating = True
Sheets("Incident_Log").Select
Cells(1, 1).Select

End Sub

!-- End of Macro

When the email arrives at the destination the file is attached and thi
is a good thing, just what I wanted in fact. However, upon opening th
file Excel is asking for the location of the original document.
don't want it to do this. Can someone help me with this.

Thanks

Lin
 

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

Top