acPRORLandscape

S

Spin

Hi,

I am trying to preset the margin and orientation of a email attachment. I am
using acSendQuery and output format acFormatXLS....I would like the
recipient to open and print the attachment as landscape with left and right
margins of 0.

Thanks for any help
Spin
 
R

Ralph

Look at the Help in Access for SendObject.

Set the EditMessage option to True, then when the email is displayed open
the workbook and change the orientation and margins.

DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _
"Nancy Davolio; Andrew Fuller", "Joan Weber", , _
"Current Spreadsheet of Employees",True
 
Top