Mailing List Excel 2007
Is there a way to export from Excel to Microsoft word? I need to create mailing labels?
I am working on Windows 2007. I have a list of over 2000 people and need to make mailing labels for them. I cant cut and paste that would take forever.
Usually, this is done by creating a mailing list in Excel and using Word’s Mail Merge feature to print the labels. Far too much to go through here, so I’ll just give a few tips:
1.For the most flexibility with the mail merge fields in Word, keep first and last names in separate cells. Ditto for the parts of the address (street address, city, state, zip).
2.Word’s Mail Merge can be found in the Tools->Letters and Mailings menu item.
3.Before wasting pages of labels, run tests on regular paper and hold the sheets up against the labels to check the layout.
4.Don’t leave the setting up to the last minute. Mail Merge can be frustrating and take more time to set up than one would think.
5.For test runs, use only enough names to be sure you’re not losing any — a little over a page should do. Skipping every other name is really easy to do.
Keep a sense of humor while you’re wrestling with it.
12 COMBINACION DE CORRESPONDENCIA CON EXCEL 2007