Mailing List Template Excel
How can I print an address on an envelope when the data is on excel?
We have to do a massive mailing to hundreds of clients. We usually print the client’s name & address on label stickers but I want to figure out if I can feed the envelopes through the printer instead of using label stickers. I have the mailing list in excel: one column has fist name, one last name, one with address #1, one with address #2, etc. The size of the envelope is a basic 9.5″ X 4.5″ inches.
I don’t know if I have to use some form of mail merge onto Word or Excel has a print envelope option. I saw the option under Tools, Letters>Letters/Mailings>Envelopes and Labels, however, I know how to use that option when drafting a letter. In this project, I do not have a formal letter that is included in this envelope (so this is not an option). Is there a Microsoft template I have to use?
It’s pretty much the same process as the one for stickers.
Start a Word document, select Tools> Mail Merge Wizard
Full insructions here:
http://www.port-huron.k12.mi.us/tech/Handouts/How-To/mailmergeenvelopes.htm
I’d suggest copying the first line of your address data into another Excel worksheet to do a test run. It might require a little experimentation to get the address to print in a good position on your envelope. You might need to work out which side up or which way round to feed envelopes into your printer.
Kinkos Mail Merge