Outlook 2007 VBA

[ronza]

Hi All,

Can anybody help with this prob I've got with outlook vba.

I have some code that opens an excel spreadsheet, copies a range of cells and pastes them into the body of and outlook new email as a table but when the email is printed the borders of the table go off the end of the printed paper.

I know you can autofit the table to window within outlook and it prints great but for the life of me I can't locate any VBA code that selects the table and autofits it to the window.

Any help appreciated.

Cheers,

Ron.

 

[loftis01]

What version of outlook are you working with??

 

[ronza]

Hi loftis01,
Thanks for getting in touch!

I am running the code in outlook 2007 but also may need it to run in outlook2003.

Any help appreciated.

Regards,

Ron.