Archive of Mr Excel Message Board


Back to Other Office and Excel archive index
Back to archive home

Mail merge

Posted by Amanda on April 10, 2001 8:17 AM
I have a mailing list in Excel and a Word document. How do I do a mail merge?

Re: Mail merge

Posted by Ian on April 11, 2001 7:59 AM

In excel, make sure your columns have heading such as Lastname, Firstname, etc.
Highlight the entire name list and name it something like Maillist in the name box.
Save the file something (ie mailing.xls)

In Word open your document.
Choose Mailmerge from the tools menue.
Under Main document, choose create, form letter, active window.
Under data source choose get data and open data source. Change the file type to .xls and select mailing.xls. Type in your range name Maillist. Hit the Edit main Document prompt. Using the mailmerge helper use the Insert Merge Field where you would like them in your document. Remember to use spaces between FirstName and LastName, etc.
Go back to the mail merge helper from the tools menu once it is formatted corrected and hit Merge. You can now print them.

good luck.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.