VBA code for mail merge -- 2
Budget: $10 – $30 AUD
I have an Excel file and a Word file with all the mail merge headings ready to go. It works fine manually selecting recipient and merging - but I am after a VBA code to be able to click a button in excel and it auto launches the word file (negating the need to open word manually), and does the mail merge automatically.
What I need is just a macro written in the Excel workbook (added to a button), which when clicked launches a specific Word document and initiates the mail merge function.
This is not a hard or long job, but you need to have a good knowledge around writing Excel VBA macros.
What I need is just a macro written in the Excel workbook (added to a button), which when clicked launches a specific Word document and initiates the mail merge function.
This is not a hard or long job, but you need to have a good knowledge around writing Excel VBA macros.