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
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.
05/31/2023: New firmware updates are available.
EOS R6 Mark II - Version 1.1.2
05/18/2023: New firmware updates are available.
EOS Rebel T100 - Version 1.1.0
EOS 5D Mark IV - Version 1.4.0
EOS 6D Mark II - Version 1.2.0
PowerShot Elph 360HS - Version 220.127.116.11
PowerShot SX420 IS - Version 18.104.22.168
PowerShot 620 HS - Version 22.214.171.124
PowerShot SX720 HS - Version 126.96.36.199
PowerShot G1X Mark III - Version 188.8.131.52
PowerShot G7X Mark II - Version 184.108.40.206
PowerShot G9X Mark II - Version 220.127.116.11
04/20/2023: New firmware version 1.4.1 is available for EOS R3
03/30/2023: New firmware updates are available.
EOS 1DX Mark III- Version 1.7.1
Speedlite EL-1 - Version 1.0.2
03/30/2023: Product Advisory for EF50 F1.2 L USM
03/30/2023: Product Advisory for EOS R10
2/07/2023: New product announcements!EOS R8 EOS R50RF-S55-210mm F5-7.1 IS STMRF24-50mm F4.5-6.3 IS STMRF15-30mm F4.5-6.3 IS STM
Canon U.S.A Inc. All Rights Reserved. Reproduction in whole or part without permission is prohibited.