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?
|