acPRORLandscape

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print with Landscape orientation 1
DoCmd.SendObject xls landscape 1
Sending Query with sendObject command 7
SendObject sends Excel attch in "old" excel format 2
Send more then one attachment in Email 1
E-mail query to recipients in table - performance and security 1
Access 2002 versus 2000 1
Interger for constant acFormatXLS 4

Back
Top