|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I permanently update the file name path in the Data Link properties?
Hopefully this will be the easiest troubleshooting thread posted on here today... Working in Excel 2010 - Excel Database connection issue for a mail merge doc... the path to the file has changed, so every time I open up the word merge doc and it tries to connect to the excel doc via a SQL statement, I get a connection error and it opens up the Data Link box where I can manually update the path. BUT, it never saves this new path (so I have to do this EVERY time I open the word doc) - I HATE IT! How can I change the path for good so that this doesn't happen? Thanks in advance for any help you can provide... |
#2
|
||||
|
||||
Hi lynn,
When you open the document and get the SQL prompt, answer 'No'. Then re-connect the mailmerge to the data source in its new location. Form then on, the new connection will be the default.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks
Thanks a lot, very helpfull.
|
Tags |
data link properties, mail merge, sql command |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to link an object to a URL link to update automatically | expert4knowledge | Excel | 1 | 06-11-2012 09:30 AM |
How to re-link default email acct folders to default Outlook Data File folders? | RDA1959 | Outlook | 0 | 03-26-2012 10:55 AM |
Relative path for video link? Is it possible? | Baudisson | PowerPoint | 1 | 01-10-2012 02:19 AM |
Update Outlook but user path changed | Ossie1972 | Outlook | 1 | 12-08-2010 08:19 PM |
MM to Access 97 lost its link - broken by Windows Update? | LesD | Mail Merge | 0 | 11-23-2010 07:13 AM |