print envelope

[Gixxer_J_97]

anyone have any ideas on how to print an envelope from excel?

or should i just play with the margins etc to find out where to set the
values and use the macro recorder to get all the pagesetup values?

thanks!

J

 

[Niek Otten]

You've probably an envelope size in your paper sizes.
File>Page Setup>Page>Paper size, select one

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Gixxer_J_97]

Thanks Niek,

that helped out actually - ended up fiddling with the left header as the
return address and then selecting a range of cells that held the address for
the delivery address. that along with the No. 10 Envelope paper setting
worked perfectly

J