I've got a simple mail merge template in word set up. I've got my FileMaker based CRM system, which has data I want to use in te MailMerge split into many tables. I can manage to do a MailMerge into MS Word which obtains data from one table from my CRM, however as the data is spread across multiple tables this solution is not suitable.
Any ideas how I can get fields from related tables (linked tables) into my MS Word MailMerge. The only thing I can think of is is to create a and temp structure which combines all the related fields in one table and ODBC off that, but surely there must be a more efficient way of doing this?