File attempts to link when sent to a different computer via e-mail

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
M

Michael Lanier

When I send a file I've created to a different computer via e-mail, it
prompts the user asking if they want to update the links. Eventually
I plan to certify the file and distribute it. Will this continue to
be a problem once certified or is there a different problem that needs
to be addressed? Thanks for any help.

Michael
 
Additional information:

I believe the reason the file attempts to update is because it is a
copy created by the following macro:

If ActiveWorkbook.Worksheets("Proposal").Range("P3").Value = "On"
And _
ActiveWorkbook.Worksheets("Proposal").Range("P4").Value > 1
Then
ActiveWorkbook.Worksheets("Proposal").Copy
ActiveWorkbook.SendMail Worksheets("Proposal").Range("P15"),
Worksheets("Proposal").Range("U17") ActiveWorkbook.Close False
End If

I'm thinking the copy is attempting to link to the original file.
Would it make sense to introduce a macro that would eliminate the
attempted link from within the copy itself?

Michael
 
Back
Top