I have some code which includes this;
It works fine, however the data is quite wide so the email has to be manually set as Landscape to be able to print it.
Is there a way to automatically set the outlook item to be landscape rather than portrait?
I thought this would work but alas not;
.PageLayout = Landscape
TIA
Code:
With ActiveSheet.MailEnvelope
.Introduction = ""
.Item.To = "email address"
.Item.Subject = "subject"
.Item.Send
End With
It works fine, however the data is quite wide so the email has to be manually set as Landscape to be able to print it.
Is there a way to automatically set the outlook item to be landscape rather than portrait?
I thought this would work but alas not;
.PageLayout = Landscape
TIA