Word 2010 send email vba current document

[Giles27]

My first post!
I have word document linked to Excel, I have VBA that updates links (to Excel), saves the changes, and breaks the links, which works as expected.

I need VBA script that attaches the unlinked file to an outlook email, the script I found on the net sends the original saved file with live links rather than the active document that has had the links broken.

I have attached the code for information.

How can I have the email code send the file with inactive links and not retrieve the original file with active links?

Many thanks for support.

Giles27

[Doug Robbins]

You are saving the document before breaking the links. Use


Break Links and Email Test Macro
'To Break Links – which works
For Each fielditem In ActiveDocument.Fields
fielditem.Update
fielditem.Unlink
Next
ActiveDocument.Save
End Sub