Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2012, 06:39 PM
macropod's Avatar
macropod macropod is offline How can I revise Excel data source in merge? Windows 7 64bit How can I revise Excel data source in merge? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Hi navysalad,


Quote:
the only way I've found to make this work is to change the name of the master Excel file so that Word can't find it, then when I get the "file not found" error message, it lets me enter the name of the local Excel file.
As previously indicated, if you open your 'master' mailmerge main document and answer 'No' to the "Opening this document will run the following SQL command:" prompt, then save, you'll no longer have the mailmerge trying to attach itself to the wrong (or any) data source. From then on, you'll only need to attach a data source for the copies.
Quote:
Is there any way to just code the local file name (with no path) into the merge process?
No, that's not possible.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I revise Excel data source in merge? Automatically Selecting a Data Source Nathan_Newlin Mail Merge 1 12-06-2011 03:42 PM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM
How can I revise Excel data source in merge? Wine List, Data Merge - Excel to Publisher - Or other suggestions? daym Publisher 2 05-01-2011 03:45 AM
pivot table source data hannu Excel 0 07-03-2010 04:54 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft