Mail Merge - Multiple Sources

[SQUiD]

Hi all




I believe what I'm attempting to achieve is similar to that in the below thread, however I haven't been able to successfully reproduce.
https://www.msofficeforums.com/mail-...-multiple.html



What I'm trying to achieve is to create one word document/letter that has been mail merged with two sources, that both contain a unique identifier to link them.


Source 1 - Content contained in a Microsoft Access table contains the the first components of the letter;



Source 2 - An excel file, that is stored locally. There is additional information to form the second component of the letter.



I am attempting to create the first part with Access info. directly from Access' merge tool then complete the second component using 'database' fields.


I'm open to doing whatever is required to achieve this as currently, I'm exporting the Access data to excel, then copy + pasting that data into source 2's excel file.