saveas help please

[ricksimm]

I've got this workbook with one sheet being an invoice. Its got all the borders around the header info and vertical lines for the columns. How can I save this sheet so that if I email the invoice sheet to somebody who doesn't have excel, they can open it as a text or doc file and it appears just as it does in my workbook. I don't know if there is a "fileformat" that will allow this or if I can save it as an image. Thanks

 

[Datsmart]

Copy the Range of cells as a picture and paste to your email.

To copy as a picture, select the range you want to copy.
Hold down the shift key and click the Edit dropdown menu.
You will see an option to "Copy as Picture".

 

[ricksimm]

Thanks but I want to do this in vba code without operator intervention. Any ideas about the code to do this?