View Single Post
 
Old 10-15-2013, 04:02 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,525
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

If you change:
Code:
Sub MakeLinks()
Application.ScreenUpdating = False
to:
Code:
Sub MailMergeToDoc()
Application.ScreenUpdating = False
ActiveDocument.MailMerge.Destination = wdSendToNewDocument
ActiveDocument.MailMerge.Execute
the macro will simply intercept the 'Finish & Merge>Edit Individual Documents' command to execute the merge then activate the links. From an end-user perspective, the process is entirely automatic.

There is another way, too, but it takes a fair bit of work to implement. Once it's set up though, no further user interaction is required. It also has the advantage of allowing you to have a display text that differs from the URL/Email address. See the Mailmerge Hyperlink ‘Click Here’ Insertion topic in the Mailmerge Tips & Tricks thread: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote