Hey all,
I'm designing a database that tracks conveyancing cases for a local solicitors. They want to be able to mail-merge client names, addresses etc in to template letters (already made). However, the only way of doing this that I can find is by selecting the table, then choosing mail-merge, then choosing the document, then choosing the fields, then choosing the record to merge.
This is very time-consuming, and I am trying to automate the system as much as possible. Basically, my question is:
Is it possible, within Access, to create a command button or macro that will automatically load up a Word document with the currently displayed information on it without the user needing to be involved in any step other than starting the process?
I'm designing a database that tracks conveyancing cases for a local solicitors. They want to be able to mail-merge client names, addresses etc in to template letters (already made). However, the only way of doing this that I can find is by selecting the table, then choosing mail-merge, then choosing the document, then choosing the fields, then choosing the record to merge.
This is very time-consuming, and I am trying to automate the system as much as possible. Basically, my question is:
Is it possible, within Access, to create a command button or macro that will automatically load up a Word document with the currently displayed information on it without the user needing to be involved in any step other than starting the process?
