Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Giolina in forum Excel Formulas & Functions
Last Post: 02-12-2013, 01:33 PM
By mschroed in forum Excel General
Last Post: 01-22-2013, 11:37 AM
By Jenn68 in forum Word Formatting & General
Last Post: 07-12-2012, 08:11 PM
By usc1382 in forum Excel General
Last Post: 01-18-2011, 01:21 PM
By Kathy at Sauder Feeds in forum Excel Formulas & Functions
Last Post: 06-30-2005, 07:05 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1