Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need to preserve hyperlink from Excel to Word merge
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need to preserve hyperlink from Excel to Word merge
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 "TapMan" wrote in message ... 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need to preserve hyperlink from Excel to Word merge
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 "Shimon" wrote in message ... 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 "TapMan" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preserve format of data in Excel when doing a mail merge | Mailmerge | |||
How to preserve a hyperlink inside a IF field | Mailmerge | |||
Preserve printed excel font color when embed in word | Microsoft Word Help | |||
preserve a hyperlink when the path of the hyperlinked file is move | Microsoft Word Help | |||
How do I enter a hyperlink from an excel sheet into mail merge? | Mailmerge |