Hello,
I need to create dynamic documents from a database in Access and then send formatted text to Word. Is there an append VB command that I could use to do this?
Right now, I am using a query in Access as a source for a mail merge, but I need a more complex system. I need Access to decide whether or not entire sections are included in the final document. I was thinking of having all the text show up in memo fields in Access and then have parts of it come together to form documents based on checkboxes the user checks off on a form. I just cant figure out the VB link between Access and Word... can anyone help or give a place to look?
Thanks!
I need to create dynamic documents from a database in Access and then send formatted text to Word. Is there an append VB command that I could use to do this?
Right now, I am using a query in Access as a source for a mail merge, but I need a more complex system. I need Access to decide whether or not entire sections are included in the final document. I was thinking of having all the text show up in memo fields in Access and then have parts of it come together to form documents based on checkboxes the user checks off on a form. I just cant figure out the VB link between Access and Word... can anyone help or give a place to look?
Thanks!