View Single Post
 
Old 05-05-2021, 03:32 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
 
Join Date: Aug 2014
Posts: 3,584
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

Mailmerge would be the obvious approach and is eminently straightforward if you provide the users with a Word envelope document attached to the Excel data. All they would have to do is open the document in Word and run the merge to the printer or to a new document.
Alternatively, you might like to consider Envelope or label add-in for Word This includes envelope templates and provided your addresses are one to a line in the Excel worksheet, you can print one, a selection or all the envelopes from the dialog.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote