ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i print from excel to envelopes (https://www.excelbanter.com/excel-discussion-misc-queries/260156-how-do-i-print-excel-envelopes.html)

gus

how do i print from excel to envelopes
 
mailing address and return address print directly to envelopes or labels from
excel

Gord Dibben

how do i print from excel to envelopes
 
There is not an easy method to do it in Excel without trial and error
manipulation.

Use Word's mailmerge...........labels and envelopes.

Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Mon, 29 Mar 2010 08:41:01 -0700, gus
wrote:

mailing address and return address print directly to envelopes or labels from
excel



Don Guillett[_2_]

how do i print from excel to envelopes
 
As Gord said, trial and error.
I have a mailing list where I simply double click on the name and it is
transferred to the envelope I have set up on another sheet. It is then
printed with a selected return address. Suggest plain paper to use to set up
where the address block goes as each printer and each envelope are
different.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gus" wrote in message
...
mailing address and return address print directly to envelopes or labels
from
excel




All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com