Hello,
I am using an Excel spreadsheet to record the information of the companies who want to establish credit with us. The problem that we had in the past is that we used to do a mail merge in Word and then save the entire document just so we have the information of that specific company, after the years, those documents have been taken a lot of memory. I know that using Access would be the best way to go as opposed to Excel. Let's take that idea off the table, and lets stick with excel, as not all the pc at work have MS Access. I want an efficient way to create a credit application and for that reason a created a form on excel that stores just the basic information in the spreadsheet and then opens up a Word document (I had enabled object library references for Excel and word). The word document takes the information from specific cells and transfer them to the document. Finally, we just print the credit application and send it to our customer. No need to save the entire word document, the basic information( name of the company, date, address...) its all save as a record in the spreadsheet. The problem is that I don't find this process to be efficient, MS word takes forever to open up and I inconsistently get this error: "424 error in vba object required".
-Any suggestions on how to create a report from data from excel? I want to stay away from MS Word.
-A 3rd party software you guys can recommend maybe?
If MS word is the best way to go, let me know, I will clean up my code.
Thank you for your help.