I have made a macro that populates a Word template based on information reviewed on an Excel Workbook, and after the review has finished successfully I generated the stated Word report. This macro works on my computer, but this process is done by various colleagues that have no idea about Mail Merge function or VBA.
I want them to download the excel file and word template into a file folder on their personal computers and have the macro work without any further assistance. Nevertheless the SQL connection gets lost every time these two files are in another computer.
Is there a way to solve through coding?
Bookmarks