resize an e-mail sheet

[John]

Hi
I have used the code on Ron de Bruin site and this works well but is it
possible to have the range of cells that is included into the e-mail redued
in size to fit an a4 page, like the shrink to fit part in excel.

I am using Excel 2003 & outlook

Thanks

 

[joel]

Do you want the worksheet put into outlook as a table or a picture? I
you want a picture then the Copy Picture method would work. then i
outlook you would have to set the Picture Height and width to match th
size yyou want. If if is a table maybe you should ask the people at th
word user group the question. You would want to scale a table to fit
certain area size