Thread: [Solved] How to always link source data (.xlsx) to same directory as Mailmergefile?
View Single Post
 
Old 01-24-2018, 02:42 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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