Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 01-24-2018, 02:42 AM
macropod's Avatar
macropod macropod is offline How to always link source data (.xlsx) to same directory as Mailmergefile? Windows 7 64bit How to always link source data (.xlsx) to same directory as Mailmergefile? 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

With a mailmerge main document, that is not possible.

A macro could be used in a mailmerge main document that has been converted back to an ordinary document (thus preserving the megefields), but that would also mean having to recreate, in the macro code, the merge type, any sheet/range references, filters etc. used for the merge. Plus you wouldn't be able to change any of the: workbook name; merge sheet name; or any relevant merge range names, without updating the macro as well. Otherwise the whole process would collapse. Unless the person responsible for managing all this is a competent coder, it would be well-nigh impossible to maintain. Imagine what's going to happen when users - being users - decide to get creative and have different workbook, sheet, etc. names to reflect their area's preferences and everything is in code...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to always link source data (.xlsx) to same directory as Mailmergefile? Unlink source files when creating Church Directory with INCLUDEPICTURE JohnFinNC Mail Merge 3 09-18-2014 08:50 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
How to always link source data (.xlsx) to same directory as Mailmergefile? How to dynamically link imbedded Excel chart with source data from Word TBoz Excel 1 07-06-2012 05:53 PM
How to always link source data (.xlsx) to same directory as Mailmergefile? Link and Keep Source Formatting--not exact minny Excel 2 04-09-2012 04:19 PM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:00 AM.


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