Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do prevent my hyperlink from 'locking up'?
I have a Word mail merge letter that uses a data source from Excel. I'm
trying to use a hyperlink in an Excel spreadsheet to open this mail merge letter. I created a hyperlink in Excel and then created a macro to open the letter by opening the hyperlink. The problem is both Word and Excel 'lock up' on me when I try to use the hyperlink to open the mail merge letter. Any ideas why? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do prevent my hyperlink from 'locking up'?
Hi ?B?bWNyZXlub2xkcw==?=,
I have a Word mail merge letter that uses a data source from Excel. I'm trying to use a hyperlink in an Excel spreadsheet to open this mail merge letter. I created a hyperlink in Excel and then created a macro to open the letter by opening the hyperlink. The problem is both Word and Excel 'lock up' on me when I try to use the hyperlink to open the mail merge letter. The Word application is visible? Are you sure that it's not waiting for you to dismiss a message box? Which version of Office are we dealing with? Is the merge letter linked to the Excel file you're currently using with the hyperlink? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do prevent my hyperlink from 'locking up'?
I'm working with Word 2003. The letter is not visible until about 60 seconds
AFTER I attempt to open the merge letter using the hyperlink created in my Excel spreadsheet. A message box pops up after the 60 seconds saying "The task is taking longer than expected. Do you want to continue waiting?" After I select 'No' both the merge letter, and the Excel data source, open up. I'm assuming the 'Task' in the message box is opening up the Excel data source? For some reason, when I use hyperlinks in Excel to open up mail merge letters there is a delay in accessing the file. Is that because an Excel database is being opened simultaneously? "Cindy M -WordMVP-" wrote: Hi ?B?bWNyZXlub2xkcw==?=, I have a Word mail merge letter that uses a data source from Excel. I'm trying to use a hyperlink in an Excel spreadsheet to open this mail merge letter. I created a hyperlink in Excel and then created a macro to open the letter by opening the hyperlink. The problem is both Word and Excel 'lock up' on me when I try to use the hyperlink to open the mail merge letter. The Word application is visible? Are you sure that it's not waiting for you to dismiss a message box? Which version of Office are we dealing with? Is the merge letter linked to the Excel file you're currently using with the hyperlink? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do prevent my hyperlink from 'locking up'?
Hi ?B?bWNyZXlub2xkcw==?=,
I'm working with Word 2003. The letter is not visible until about 60 seconds AFTER I attempt to open the merge letter using the hyperlink created in my Excel spreadsheet. A message box pops up after the 60 seconds saying "The task is taking longer than expected. Do you want to continue waiting?" After I select 'No' both the merge letter, and the Excel data source, open up. OK, this sounds as if DDE is being used to link in the data. In this case, I'd try using an ODBC data connection to the Excel data source file. That will let mail merge work without having to open the data source file (indeed, Excel need not even be present on the machine when using ODBC). However, an ODBC connection would have one drawback: the numerical and date formatting would not come across from the worksheet. You'd have to duplicate this in the merge fields of the main merge document. Does it sound as if this approach would work for you? I'm assuming the 'Task' in the message box is opening up the Excel data source? For some reason, when I use hyperlinks in Excel to open up mail merge letters there is a delay in accessing the file. Is that because an Excel database is being opened simultaneously? I have a Word mail merge letter that uses a data source from Excel. I'm trying to use a hyperlink in an Excel spreadsheet to open this mail merge letter. I created a hyperlink in Excel and then created a macro to open the letter by opening the hyperlink. The problem is both Word and Excel 'lock up' on me when I try to use the hyperlink to open the mail merge letter. The Word application is visible? Are you sure that it's not waiting for you to dismiss a message box? Which version of Office are we dealing with? Is the merge letter linked to the Excel file you're currently using with the hyperlink? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Hyperlink: Opening & Returning | Microsoft Word Help | |||
How do I prevent Word from locking the file? | New Users | |||
Hyperlink in Word Attachment | Microsoft Word Help | |||
hyperlink | Microsoft Word Help | |||
Using MAILMERGE fields within HYPERLINK fields for Merge to Email | Mailmerge |