03-30-2014 05:48 PM
I have an excel spreadsheet with addresses and names. How do I output them using Word to my MX860 printer? One by one or as a group? How do I set up the paper options? Can I make the addresses a pretty color? I've never done envelopes, much less excel, so this is a learning experience. Have a week to figure it all out.
04-21-2014 09:27 AM
Hi wegolf,
You would need to import the names and addresses into Microsoft Word from Excel, then you could use the envelopes and label function of Microsoft Word to customize and print the data out. The printer itself would not perform any of these functions; it would simply print out what you have configured in the applications.
We recommend contacting Microsoft for assistance with exporting the data from Excel and importing it into Word, and then customizing the look of the envelope/label data. Please click here to go to the Microsoft Support Community website.
This didn't answer your question or issue? Find more help at Contact Us.
04-21-2014 10:34 AM
For the future, the printer worked quite well. We did a mail merge of the excel and word. We did, however, have to print out the envelopes, one by one. We set the size under custom. The back envelope slot would hold about 5 envelopes at a time. We ended up printing them in black ink (couldn't figure out colors) and used Lucinda Handwriting in a 16 font. Once we had it figured out, it went quite fast.
Our biggest problem was adjusting the names when they didn't fit on a line or had an address change. Those required going back into the excel to make the change and then updating the mail merge before printing. Most of our messed up envelopes were due to this. Hope this helps future brides and party planners.
09/26/2024: New firmware updates are available.
EOS R5 Mark II - Version 1.0.1
EOS R6 Mark II - Version 1.5.0
07/01/2024: New firmware updates are available.
04/16/2024: New firmware updates are available.
RF100-300mm F2.8 L IS USM - Version 1.0.6
RF400mm F2.8 L IS USM - Version 1.0.6
RF600mm F4 L IS USM - Version 1.0.6
RF800mm F5.6 L IS USM - Version 1.0.4
RF1200mm F8 L IS USM - Version 1.0.4
Canon U.S.A Inc. All Rights Reserved. Reproduction in whole or part without permission is prohibited.