I'd like to set a macro to print envelopes from one Excel worksheet at a
time. Mail-merge not so good for one sheet at a time. Any way of setting a
macro to work across office products (i.e. Word)?
thanks,
al

the excel spreadsheet is essentially
a database that word can link to
for mail merging.

however, mail merging in word
does not have to be with a sheet
of labels, eg 30 labels per sheet.

instead of setting up a label sheet
30 sets of fields that would be poplulated
by the database at merge, set up an
envelope with one set of fields instead.

the merge will then make 30 envelopes
or however many sets of addresses you
have that will be merged.

you can do a trial test with maybe 3
sets of addresses in a test spreadsheet
in excel with a test envelope in word.

- db
"al" <acontente@cox.net> wrote in message news:FE51BF90-1DA2-4B26-AD98-0B27F1952989@microsoft.com...
I'd like to set a macro to print envelopes from one Excel worksheet at a
time. Mail-merge not so good for one sheet at a time. Any way of setting a
macro to work across office products (i.e. Word)?
thanks,
al