Create a button in Excel that create a mail merge in Word
I have a list in Excel that I add to each day. A few times a month I take this list and create a mail merge in Word. Is there a way to automate this process with some kind of button in Excel where I click on this button, it then creates the mail merge for me in Word? It would also be nice it the merge in Word remembered my format. I basically print 2 addresses per 8 1/2 x 11 sheet of paper. I cut the 8 1/2 x 11 sheet in half. So one address is at the top and the other is on the bottom half. I am just trying to find ways to make the mail merge be a little more automated. Any ideas? Thanks!
CustomerName, Address1, Address2, City, State, Zip