How to build database correctly

[frankt68]

I am not sure, is it possible to use Access table or saved query as source for Mail Merge - I have used only Excel for this.

It is possible to use queries as data source for Mail Merge, here is one instruction how to do it.
https://support.office.com/en-us/art...b-5c8a34c7e89d

And of course you can create an Excel workbook which queries data from access DB, and set the query to be refreshed on opening. And you create a Mail Merge in Word with this Excel workbook as source.

I did, exept that I didn't use Mail Merge. Insteadt, I export data from excel to word for a single employee.

[frankt68]

I.e. a word document for single employee. It look like a task for Mail Merge. I am not sure, is it possible to use Access table or saved query as source for Mail Merge - I have used only Excel for this. But maybe someone here has some experience with this!

It is possible - look here for example: https://support.office.com/en-us/art...b-5c8a34c7e89d

And of course you can create an Excel workbook which queries data from access DB, and set the query to be refreshed on opening. And you create a Mail Merge in Word with this Excel workbook as source.

Indeed, I created an Excel workbook to query data from Access DB, but I didn't do the mail merge; I exported data for single employee and save it as an word document.