Basically, I know how to create a normal mail merge already but now I am planning to code it in a different way. I was wondering if anyone knows how to do this/ has done this themselves.
I want the user to click a macro in my database (As usual), then the coding will tell Access where to save the file. The user will be asked if they wish to use their template or a blank document (or there could be seperate macros for the two options). If the user wants to use their template access will automatically find the template and input details in the correct places. After this word will stay open so that the user can edit it and print it as needed.
I am using Office 2010 just so you know...
Any pointers or ideas would be great!
Thanks
Rebecca.
I want the user to click a macro in my database (As usual), then the coding will tell Access where to save the file. The user will be asked if they wish to use their template or a blank document (or there could be seperate macros for the two options). If the user wants to use their template access will automatically find the template and input details in the correct places. After this word will stay open so that the user can edit it and print it as needed.
I am using Office 2010 just so you know...
Any pointers or ideas would be great!
Thanks
Rebecca.