<div>
My spreadsheet with address has these columns...if it helps:<br />
CustomerName, Address1, Address2, City, State, Zip
</div>


My spreadsheet with address has these columns...if it helps:
CustomerName, Address1, Address2, City, State, Zip

<div>
Thanks Rob! So how do I setup that data link?
</div>


Thanks Rob! So how do I setup that data link?

<div>
Use the Mail Merge wizard in Word to create the document, one step of which will be to define data source.
</div>


Use the Mail Merge wizard in Word to create the document, one step of which will be to define data source.

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 500 points for Rob Henson's comment <a href="https://www.experts-exchange.com/questions/28632646/Create-a-button-in-Excel-that-create-a-mail-merge-in-Word.html?anchorAnswerId=40656098#a40656098" rel="ugc">#a40656098</a><br />
<br />
for the following reason:<br />
<br />
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


I've requested that this question be closed as follows:

Accepted answer: 500 points for Rob Henson's comment #a40656098 [https://www.experts-exchange.com/questions/28632646/Create-a-button-in-Excel-that-create-a-mail-merge-in-Word.html?anchorAnswerId=40656098#a40656098]

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
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!
</div>
</div>


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!

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.