I am very new to VBA programming and have found this forum very useful to compile a number of VBA projects over the last year.

I currently have a single work book that opens as a Userform for data entry. Once the correct data has been entered and checked the form closes and open the mail merge workbook. if i open the mail merge workbook on its own then it runs without issue. when i call it from the data workbook then is does nothing.

I have attached the two workbooks for reference. to be able to set the merge target and destination files press on the company logo

any help or suggestions greatly appreciated.



MailMerge.xlsm Sales Order Confirmation.xlsm