MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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.