We help IT Professionals succeed at work.
Get Started

Create a button in Excel that create a mail merge in Word

Last Modified: 2016-02-10
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!
Watch Question
Finance Analyst
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE