What you're describing may be amenable to mailmerge. With a mailmerge, the output remains static (though you could use a preview, if that's all you need), that has its own advantages and generating an update is as simple as re-executing the merge. That also obviates any linkage issues when the mailmerge output document is emailed to someone else.



If, for some reason, you need to email the mailmerge main document, rather than the output document, re-establishing the mailmerge connection is much simpler than updating perhaps dozens of separate links.

If you're wedded to using links, though, and the email recipient's computer isn't connected to your network, you'll need to send the Excel workbook as well. Provided the Word document and the Excel workbook are stored in the same folder, you can use the macro attached to my post at http://windowssecrets.com/forums/sho...External-Files to do the link updating.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]