Word MailMerge Macro in Excel'

  • Hi

    I have used the "Record Macro" Function to write the below code in word. I then copied it to Excel cause I want excel to open word and create the mailmerge word document from addresses in the mailmerge.xls file. I have turned on the references to Word VBA scripts in the options and the macro runs to the point of opening word and creating a blank sheet but no further. Please is someone able to spot the flaw in my code? I've marked the place where the 'Debug' tool always highlights if it helps at all.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!