Hi all,
I'm looking for some VBA code to automate a mail merge from Excel to Word.
I have a customer letter built in a Word Template with Mail Merge fields in place. The data source (one row only) is in a worksheet called MailMerge in Excel. I can successfully merge the data manually from Word, however would like to automate this within Excel.
Users enter data in cells in excel and there will only ever be one row of data to merge. I'd like them to press a button, which opens Word, conducts the merge and saves as a Word document with a name containing Merge data (Let's call it the <Customer_Ref> field), leaving the document open to edit.
I've searched for the answer all over to no avail.
Can anyone help without sending you the documents?
Regards,
Pitmo.
I'm looking for some VBA code to automate a mail merge from Excel to Word.
I have a customer letter built in a Word Template with Mail Merge fields in place. The data source (one row only) is in a worksheet called MailMerge in Excel. I can successfully merge the data manually from Word, however would like to automate this within Excel.
Users enter data in cells in excel and there will only ever be one row of data to merge. I'd like them to press a button, which opens Word, conducts the merge and saves as a Word document with a name containing Merge data (Let's call it the <Customer_Ref> field), leaving the document open to edit.
I've searched for the answer all over to no avail.
Can anyone help without sending you the documents?
Regards,
Pitmo.