I have been racking my brain in VBA. have a form that generates an Access report nicely. However, I would prefer it in MS word as the document is routed in Sharepoint late for further editing.
Three things I am trying to do.
1. I would like to export data from an active form to a predefined MS word template. (*.docx format, RTF drops formatting, so I use a template)
2. save the created active word document with the file name set to a specific field name from that report.
3. Upload "Save As." [field name].docx to a sharepoint directory.
I can do this with a macro as an RTF format but need to preserve formatting. Stuck.
I can provide examples of my database if you like?
Thanks in advance, Troy