Hey Gang
I have a macro that selects the print area of a single page in a workbook and emails it to a list. When the page is received and viewed it displays as two pages (Front & back of the page). But when the people receive the page and attempt to print it it defaults to printing 6 pages and is unreadable. Is there a way of setting the print area on the page I send so as it only prints on 2 pages one for the front and one for the back.
Thanks in advance
Cheers
Bob
I have a macro that selects the print area of a single page in a workbook and emails it to a list. When the page is received and viewed it displays as two pages (Front & back of the page). But when the people receive the page and attempt to print it it defaults to printing 6 pages and is unreadable. Is there a way of setting the print area on the page I send so as it only prints on 2 pages one for the front and one for the back.
Thanks in advance
Cheers
Bob