This may help: In Excel 2002/XP help, I put in this phrase: Create a Word mail merge with Excel data.
It gives steps on how to do it. I just did a spreadsheet containing names and addresses, worked like a charm. A big key is having no blank rows or columns, blank cells okay, as is having First name, Last name, Address, City, State, and Zip Code as column headers. Did have a little problem getting the Zip Code column to be complete but copying the column and then pasting it in the Word document worked.
Save the file with a new name and where you can find it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.