Need to preserve hyperlink from Excel to Word merge

[TapMan]

I've read many of the posts regarding this subject and they all seem to apply
to doing a mail merge to an email, I have a different situation.

I need to mail merge data from Excel into Word concerning land ownership
information. The data in Excel has one cell that is a hyperlink to a PDF file
on a DVD in the DVD drive. That hyperlink pulls up an PDF image of a legal
document. I want to mial merge the information into Word and pull over that
hyperlink to the PDF file on my computer. That way when I send the DVD and
the mail merged "directory" I have created to an attorney, he can view the
information in Word and click on the hyperlink to access the image of the
document.

Any ideas on how to preserve the hyperlink to the PDF on the DVD during a
mail merge?

 

[Shimon]

I have once written a macro that runs through the whole document and makes
hyperlinks out of every http:\\whatever.com\whateverpage. what it dd was
select the whole document and turned on the create hyperlink automatically.
I'll try to find the code, but I'm not sure if it'll work on a hyperlink to
a DVD.
You also have to take into consideration that unless you assign a specific
drive letter for your DVD, which is easy to do in WnXP, and the recepient
has the same drive letter assigned, you will have a problem creating and
using the hyperlinks.
I'm sure that programatticaly , you can have a script that checks what drive
his DVD is, and then have the script run through the document and change the
hyperlinks, but that is probably beyond your technical abilites, and it is
probably an overkill for the problem at hand.
I would suggest you trying a different route. Maybe embedd all the images
into the word document and burn the document to a DVD.
All the best,
Shimon

 

[Shimon]

This is code scratched up, bt i did not figure out how to use it for a
hyperlink to a local file, maybe you can store the files on a FTP share.

Sub Macro1()
Selection.WholeStory
' using an ftp share \\ftpServer\cdShare\Doc1.doc as the name of
the document reffered to,
With Options
.AutoFormatReplaceHyperlinks = True
.AutoFormatPreserveStyles = True
End With
Selection.Document.Kind = wdDocumentNotSpecified
Selection.Range.AutoFormat
End Sub