Mail Merge to Separate Document but Group by Common Cell

In Your workbook, create a sheet named 'Stores' having a list of stores. Then add the following macro to your workbook and run the merge from that.

Please Login or Register  to view this content.

When you're satisfied the code is working correctly, you can change:
wdApp.Visible = True
to:
wdApp.Visible = False

Note: The macro assumes your 'Test Letter' and your workbook are stored in the same folder - which also where the output will go. Naturally, since your actual mailmerge main document and mailmerge sheet names are unlikely to be named 'Test Letter' and 'Sheet1', respectively, you'll need to change those names in the code, too. And, if you already have another worksheet in the same workbook that has a store listing, you might use that instead of creating a 'Stores' worksheet - but you'll also need to change that sheet reference in the code.

Thanks for the help. I'm a little by confused. Should I be running the merge like normal through Word or a different way. I try to run macro & getting the attached error. Should I save the test data as a macro enabled workbook first?

I couldn't upload image of error
Compile error:
User-defined type not defined

It selected "wdApp As New Word.Application"

As I said:

Originally Posted by macropod

add the following macro to your workbook and run the merge from that.

There is nothing attached to your post. Ideally, you would save the workbook as a macro enabled one before running the macro, but that's not strictly necessary. Pay attention, too to the note at the top of the macro.

I don't know where the 4 came from, it's supposed to be lRow. Corrected.