print envelope
 

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

print envelope
 

You've probably an envelope size in your paper sizes.
FilePage SetupPagePaper size, select one

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"Gixxer_J_97" wrote in message
...
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

print envelope
 

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

"Niek Otten" wrote:

You've probably an envelope size in your paper sizes.
FilePage SetupPagePaper size, select one

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"Gixxer_J_97" wrote in message
...
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