Hi everyone
I use MS Office 2003 and have seen several threads which give samples that have forms and code to take data from Access and merge it automatically to a Word document. That's fine, but is it possible to have a unique document reference ("Our ref:" in the Word document) which is stored in the database, along with the date of the letter and the document name and path? I know that I could have a table into which this information is stored manually, but I'd like to have this occur automatically. I suspect that it is possible - presumably Access would generate the unique reference and merge it into a reference merge field or bookmark in the document but Word would also have to "write" back to Access to let it know the file name and path where it's been saved?
Does anyone have any experience of this or know of a sample DB anywhere that I could look at? Is this approach correct or should I be thinking of something else completely?
Thanks for your time.
Juan
I use MS Office 2003 and have seen several threads which give samples that have forms and code to take data from Access and merge it automatically to a Word document. That's fine, but is it possible to have a unique document reference ("Our ref:" in the Word document) which is stored in the database, along with the date of the letter and the document name and path? I know that I could have a table into which this information is stored manually, but I'd like to have this occur automatically. I suspect that it is possible - presumably Access would generate the unique reference and merge it into a reference merge field or bookmark in the document but Word would also have to "write" back to Access to let it know the file name and path where it's been saved?
Does anyone have any experience of this or know of a sample DB anywhere that I could look at? Is this approach correct or should I be thinking of something else completely?
Thanks for your time.
Juan
