View Single Post
 
Old 02-11-2015, 09:49 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote