View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
PY & Associates
 
Posts: n/a
Default print envelopes from excel data

If each row of your database occupies columns A to K;
design your envelope using =M1, N1 etc;
set your print area to the envelope;
now copy any of the address row (A to K) to M1;
you have an envelope.

"lele" wrote in message
...
I have an excel database of addresses and I want to print off envelopes

with
the addresses I have listed in this document. I have read about linking

excel
with mail merge, but is there a faster method? More often I want to be

able
to print off envelopes 2 or 3 at a time, so to use mail merge seems
time-consuming. Is there a way through formulas to somehow transfer for
example one row of data into word and it generate into an address format.

Or
even better is there an envelope printing function in excel, as in word?