Mail Merge. Forced Prompt for New Data Source?

[Gongalong]

Hi folks,

 

One of our departments regularly mail merges a (Word) label template with one of several spreadsheets.

 

They somehow had this setup that whenever you open the Word document it prompts for the spreadsheet location. I cannot see where in mail merging, or elsewhere, you can set it to always prompt.

 

They now want to use a new Word template but have this same prompt behaviour.

 

Anyone know how this is configured?

 

Thanks

[howartp]

Hi

 

I'm wondering if this is actually an unintentional bug they were making use of.

 

If your data source is CSV, then some versions of Office will fail to find the original source and re-prompt you for it.

If your data source is XLS(X) then it finds it and re-uses it.

 

I hate it cos most of my sources are CSV and I have to re-browse every time.

[Gongalong]

These are definitely XLSX files. It's a weird one. I've found a rather clumsy workaround, but it does work. I can move a spreadsheet and the label template (Word file) to a different directory, open the Word file, and connect up the spreadsheet again. I can then move the files back and set the Word file to be read only. Then it always prompts to open the data source as the changes to the new data source cannot be saved. It means three extra clicks when opening before you get the data source prompt, that's the only difference.