Excell macro in Access code

G

Gerald Bennett

Joined
Dec 23, 2005
Messages
1
Reaction score
0
I am using the SendObject method to send an access report as an excel file via email. This works fine but when the spreadsheet is opened the columns are greatly expanded and the rows are not of equal height.

DoCmd.SendObject acSendReport, "rptparks", acSpreadsheetTypeExcel5, "(e-mail address removed)", , , "Current Park List", , False



Does anyone know how to include code for an excell macro in the access code that will correctly format the spreadsheet?
 
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

How to attach file into email 3
SendObject to send email 2
Issues when opening excel through access 10
Import Excel named range into Access 2
Email reports in 2007 1
SendObject doesn't find fields in querry 1
How to cause a spreadsheet (Excel) to run from an Access Macro 4
How do I code an Excel formula in Access VBA 9

Back
Top